| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | David Scott <davids(at)apptechsys(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: No heap lookups on index |
| Date: | 2006-01-19 20:06:07 |
| Message-ID: | 20060119200607.GZ78403@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Thu, Jan 19, 2006 at 10:35:30AM -0800, David Scott wrote:
> Tom Lane wrote:
>
> >What sort of problems are you dealing with exactly? There has been
> >some discussion of changes that would improve certain scenarios. For
> >instance it might be plausible to do joins using index information and
> >only go back to the heap for entries that appear to pass the join test.
Do you still have that patch that folks could look at? ISTM that this
technique would be rather dependant on your actual workload, and as such
could result in a big win for certain types of queries.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed L. | 2006-01-19 20:38:02 | 7.4.11 HP-UX ia64 build error |
| Previous Message | Jim C. Nasby | 2006-01-19 20:03:17 | Re: No heap lookups on index |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mark | 2006-01-19 20:11:04 | Re: Surrogate keys (Was: enums) |
| Previous Message | Jim C. Nasby | 2006-01-19 20:03:17 | Re: No heap lookups on index |