Re: Index not used on a DISTINCT ON

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Index not used on a DISTINCT ON
Date: 2003-03-22 01:50:36
Message-ID: 26920.1048297836@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Gaetano Mendola" <mendola(at)bigfoot(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message P G 2003-03-22 02:26:51 Re: HOW TO UPGRADE POSTGRES 7.2 TO 7.3 IN RPM FORMAT
Previous Message Mario Alberto Soto Cordones 2003-03-21 23:38:51 HOW TO UPGRADE POSTGRES 7.2 TO 7.3 IN RPM FORMAT