Re: Our CLUSTER implementation is pessimal

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