Re: I: About "Our CLUSTER implementation is pessimal" patch - Mailing list pgsql-hackers

From Robert Haas
Subject Re: I: About "Our CLUSTER implementation is pessimal" patch
Date
Msg-id AANLkTikHNAm+t2-Fe-RcBcnHOGT_oAwCBeXTh_RRz_A9@mail.gmail.com
Whole thread Raw
In response to Re: I: About "Our CLUSTER implementation is pessimal" patch  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-hackers
On Fri, Oct 1, 2010 at 4:33 AM, Leonardo Francalanci <m_lists@yahoo.it> wrote:
> I guess that if the planner makes a wrong choice in this case (that is,
> seq scan + sort instead of index scan) there's no way for "cluster" to
> behave in a different way. If, on the contrary, the "create table..." uses
> the right plan, and cluster doesn't, we have a problem in the patch.
> Am I right?

Good point.  I think you're right.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: wip: functions median and percentile
Next
From: Tom Lane
Date:
Subject: Re: patch: SQL/MED(FDW) DDL