| From: | David Hartwig <daybee(at)bellatlantic(dot)net> |
|---|---|
| To: | hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Clean up prepkeyset.c |
| Date: | 1998-09-04 01:05:18 |
| Message-ID: | 35EF3CCE.30456BE5@bellatlantic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I put some extra checks to make sure a query was a good candidate for
rewrite into a UNION. Besides the existing checks:
1. Make sure the AND/OR tree was rectangular. ( i.e. 3 X 4 or 10 X
3)
2. Only one table.
3. Must have an AND dimension.
4. At least 9 OP expressions total
Also cleaned up and commented.
| Attachment | Content-Type | Size |
|---|---|---|
| prepkeyset.patch | text/plain | 7.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas G. Lockhart | 1998-09-04 01:22:30 | Re: [HACKERS] index fix report |
| Previous Message | Bruce Momjian | 1998-09-04 01:02:21 | Re: [GENERAL] big numbers |