Re: Our CLUSTER implementation is pessimal - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Our CLUSTER implementation is pessimal
Date
Msg-id 1220872291.3913.124.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Our CLUSTER implementation is pessimal  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Mon, 2008-09-08 at 13:52 +0300, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > I think there needs to be an option to force this to do either sorts or
> > indexscans. 
> 
> If we use the planner, "set enable_indexscan =off" or "set 
> enable_sort=off" ought to work.

Agreed - as long as that is explicitly in the docs.

I'm wondering whether we should put a limit on size of each temp
tablespace. This change will cause old admin jobs to break disks that
aren't big enough for the new way of doing it.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [PATCH] Cleanup of GUC units code
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: Synchronous Log Shipping Replication