On 7/16/2004 11:59 PM, Erik G. Burrows wrote:

>> What is the size of your database, the size of your shared buffer 
>> configuration, the work_mem settings and what is the read/write ratio of 
>> your applications database access pattern? What is the average, min and 
>> max row size of the replicated data?
> 
> DB size is about 3GB. System RAM is 2GB. Shared buffers are at 16384
> (130MB). Read/write ratio is probably over 99% read oriented. Row sizes
> are fairly average. No huge strings, and column counts are sane, 5-20
> columns per table, about 60 tables.

Under all those conditions you listed, I would shoot for the FSM. Adjust 
max_fsm_pages to 250000 (yes, that's a quarter million), restart the 
postmaster and do a "vacuum full analyze" on the whole database. Then 
arrange for frequent vacuuming with pg_autovacuum or your own schedule.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #