| From: | Markus Wanner <markus(at)bluegap(dot)ch> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Index scan troubles |
| Date: | 2008-09-02 18:57:38 |
| Message-ID: | 48BD8CA2.7050204@bluegap.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Gregory Stark wrote:
> It's right for your equality case which is effectively x=const, y=const,
> z=const. It's not for row comparisons case for which you need a funny "header"
> ScanKey. See the comments in access/skey.h, search for "row comparisons". I'm
> not sure if there's a function to create this for you or if you have to do it
> yourself. Search for other places where SK_ROW_HEADER appears.
Ah, so the default for multiple ScanKeys is 'x > const AND y > const'
and not the row comparison. That explains my troubles. Thanks a lot.
Regards
Markus Wanner
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-09-02 19:01:53 | Re: WIP patch: Collation support |
| Previous Message | Alvaro Herrera | 2008-09-02 18:47:08 | Re: WIP patch: Collation support |