diff options
| author | Dan McGee <dan@archlinux.org> | 2013-01-20 14:59:30 -0600 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2013-01-20 15:01:13 -0600 |
| commit | 1b1b516bd823d807ea81e62fe14fc92c18d0b89d (patch) | |
| tree | dc5360125caaa5a7a483a750b3e678012f4d757d /packages | |
| parent | dd8e94f69783365160bcbfda61a9bebea5a71324 (diff) | |
Query performance enhancements in get_requiredby()
For packages with particularly long lists of provides (e.g. perl), the
query was getting a bit out of control with the list of names passed in.
However, changing it to simply do a subquery resulted in some really
poor planning by PostgreSQL. Doing this as a custom 'WHERE' clause
utilizing the 'UNION ALL' SQL operator works very well.
Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'packages')
0 files changed, 0 insertions, 0 deletions