Re: [PERFORM] cluster on conditional index?

2012-08-14 Thread k...@rice.edu
On Tue, Aug 14, 2012 at 10:10:47AM -0700, Jeff Janes wrote: > On Tue, Aug 14, 2012 at 8:27 AM, Doug Hunley wrote: > > According to the docs on cluster: > > if you tend to access some data more than others, and there is an > > index that groups them together, you will benefit from using CLUSTER > >

Re: [PERFORM] cluster on conditional index?

2012-08-14 Thread Jeff Janes
On Tue, Aug 14, 2012 at 8:27 AM, Doug Hunley wrote: > According to the docs on cluster: > if you tend to access some data more than others, and there is an > index that groups them together, you will benefit from using CLUSTER > > however, this doesn't address the situation where you have a > cond

[PERFORM] cluster on conditional index?

2012-08-14 Thread Doug Hunley
According to the docs on cluster: if you tend to access some data more than others, and there is an index that groups them together, you will benefit from using CLUSTER however, this doesn't address the situation where you have a conditional index. For example, we have certain large tables that ha