Skip site navigation (1) Skip section navigation (2)

Re: caching indexes and pages?

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Thomas Finneid <tfinneid(at)fcon(dot)no>
Cc: Thomas Markus <t(dot)markus(at)proventis(dot)net>,pgsql-performance(at)postgresql(dot)org
Subject: Re: caching indexes and pages?
Date: 2009-01-23 05:52:05
Message-ID: 49795B05.1050800@postnewspapers.com.au (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Ibrahim HarraniDate: 2009-01-23 05:52:36
Subject: Re: postgresql 8.3 tps rate
Previous:From: Greg SmithDate: 2009-01-23 03:52:47
Subject: Re: postgresql 8.3 tps rate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group