Thomas Markus wrote:
> try to reorganize your data with CLUSTER and create appropriate indixes
> (dont forget to check statistics).
One question. Assume I have clustered and new data has been added after
that, according to the docs that data is added "outside" of the
clustered data. What happens when I run cluster again? I would assume
its smart and to only clusteres the new data, i.e. adding it to the
already created clusters, as apporpriate, so the execution time would be
a lot lower, right? or would it run through and recluster everything
from scratch again?
In response to
pgsql-performance by date
|Next:||From: Kenneth Marshall||Date: 2009-01-22 22:03:33|
|Subject: Re: caching indexes and pages?|
|Previous:||From: David Rees||Date: 2009-01-22 21:41:25|
|Subject: Re: postgresql 8.3 tps rate|