In response to Douglas J Hunley <[EMAIL PROTECTED]>:
> On Wednesday 27 February 2008 13:35:16 Douglas J Hunley wrote:
> > > > 2) is there any internal data in the db that would allow me to
> > > > programmatically determine which tables would benefit from being
> > > > clustered? 3) for that matte
On Wednesday 27 February 2008 13:35:16 Douglas J Hunley wrote:
> > > 2) is there any internal data in the db that would allow me to
> > > programmatically determine which tables would benefit from being
> > > clustered? 3) for that matter, is there info to allow me to determine
> > > which index it
On Wednesday 27 February 2008 12:40:57 Bill Moran wrote:
> In response to Douglas J Hunley <[EMAIL PROTECTED]>:
> > After reviewing
> > http://www.postgresql.org/docs/8.3/static/sql-cluster.html a couple of
> > times, I have some questions:
> > 1) it says to run analyze after doing a cluster. i'm a
In response to Douglas J Hunley <[EMAIL PROTECTED]>:
> After reviewing http://www.postgresql.org/docs/8.3/static/sql-cluster.html a
> couple of times, I have some questions:
> 1) it says to run analyze after doing a cluster. i'm assuming autovacuum will
> take care of this? or should i go ahead
After reviewing http://www.postgresql.org/docs/8.3/static/sql-cluster.html a
couple of times, I have some questions:
1) it says to run analyze after doing a cluster. i'm assuming autovacuum will
take care of this? or should i go ahead and do the analyze 'now' instead of
waiting?
2) is there any
