On Thu, Jan 22, 2009 at 10:58:25PM +0100, Thomas Finneid wrote:
> 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?
It reclusters again from scratch. You do get better performance on the
reads from the data that is already clustered.
In response to
pgsql-performance by date
|Next:||From: Ibrahim Harrani||Date: 2009-01-22 22:29:57|
|Subject: Re: postgresql 8.3 tps rate|
|Previous:||From: Thomas Finneid||Date: 2009-01-22 21:58:25|
|Subject: Re: caching indexes and pages?|