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

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

4 years ago

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

4 years ago

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

4 years ago

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

4 years ago

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

4 years ago

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

4 years ago

Login to comment on this ticket.

Metadata
Related Pull Requests
  • #2060 Merged 4 years ago
  • #2032 Merged 4 years ago
  • #1962 Merged 4 years ago