Re: caching indexes and pages? - Mailing list pgsql-performance

From Craig Ringer
Subject Re: caching indexes and pages?
Date
Msg-id 49795B05.1050800@postnewspapers.com.au
Whole thread Raw
In response to Re: caching indexes and pages?  (Thomas Finneid <tfinneid@fcon.no>)
List pgsql-performance
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.

Check into FILLFACTOR (on both tables and indexes).

--
Craig Ringer

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: postgresql 8.3 tps rate
Next
From: Ibrahim Harrani
Date:
Subject: Re: postgresql 8.3 tps rate