koji

#1961 SQL effectivity for build_references
Closed: Fixed by tkopecek. Opened by tkopecek.

Closed: Fixed
Reopen Issue

join inside the function needs too much temporary space and it is slow because of this

2020-01-21 13:15:31 UTC [14464]: [29-1] user=brew,db=brew LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp14464.22", size 18014528
2020-01-21 13:15:31 UTC [14464]: [30-1] user=brew,db=brew STATEMENT:  SELECT count(standard_buildroot.create_event) FROM buildroot_listing JOIN standard_buildroot ON buildroot_listing.buildroot_id = standard_buildroot.buildroot_id WHERE buildroot_listing.rpm_id IN (849093, 849094);

Using subselect improves it.

Metadata Update from @jcupova:
- Custom field Size adjusted to None
- Issue tagged with: testing-ready

PR #1962
Edited by tkopecek

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.20.1 (was: 1.21)

Metadata Update from @jcupova:
- Issue tagged with: testing-done

Commit 9d25189b fixes this issue

Commit 3c6fb598 fixes this issue

Metadata Update from @julian8628:
- Issue status updated to: Open (was: Closed)

a small fix: PR #2060

Metadata Update from @julian8628:
- Issue untagged with: testing-done

Metadata Update from @jcupova:
- Issue tagged with: testing-done

Commit 86827f7b fixes this issue

Commit fa613108 fixes this issue

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/1961

Please continue any further discussion there.
Metadata
None

testing-done testing-ready

None
None
Low
None
Related Pull Requests
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.