Postgres Pro
Downloads
Home   >   mailing lists

Re: Index not used on a DISTINCT ON - Mailing list pgsql-admin

From Tom Lane
Subject Re: Index not used on a DISTINCT ON
Date
Msg-id 26920.1048297836@sss.pgh.pa.us
Whole thread Raw
In response to Index not used on a DISTINCT ON  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
Tree view 
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> the index is not used if I remove the DISTINCT ON
> the filter is used!!!
> Is it a known issue ?

Okay, okay already ;-)

This has been on my to-fix list for awhile.  It's fixed now for 7.4.

            regards, tom lane

pgsql-admin by date:

Previous
From: Justin Tocci
Date:
Subject: Local guru wanted: Fort Wayne Indiana
Next
From: P G
Date:
Subject: Re: HOW TO UPGRADE POSTGRES 7.2 TO 7.3 IN RPM FORMAT