pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matthew T. O'Connor <matthew@zeut.net>
To: Joe Conway <mail@joeconway.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: rapid degradation after postmaster restart
Date: Sat, 13 Mar 2004 12:33:43 -0500
Message-ID: <405345F7.7080803@zeut.net> (raw)
In-Reply-To: <405330CD.4050304@joeconway.com>
References: <4052661D.5060505@joeconway.com>
	<18481.1079192379@sss.pgh.pa.us>
	<405330CD.4050304@joeconway.com>

Joe Conway wrote:

> Tom Lane wrote:
>
>> Just to be clear on this: you have to restart the postmaster to bring
>> the time back down?  Simply starting a fresh backend session doesn't do
>> it?
>
>
> IIRC, shared buffers was reasonable, maybe 128MB. One thing that is 
> worthy of note is that they are using pg_autovacuum and a very low 
> vacuum_mem setting (1024). But I also believe that max_fsm_relations 
> and max_fsm_pages have been bumped up from default (something like 
> 10000 & 200000).
>

pg_autovacuum could be a problem if it's vacuuming too often.  Have you 
looked to see if a vacuum or analyze is running while the server is 
slow?  If so, have you played with the pg_autovacuum default vacuum and 
analyze thresholds?  If it appears that it is related to pg_autovacuum 
please send me the command options used to run it and a logfile of it's 
output running at at a debug level of -d2


Matthew




view thread (26+ messages)  latest in thread

Message-ID: <405345F7.7080803@zeut.net>
Permalink:  ../405345F7.7080803@zeut.net/
Also on:    postgresql.org/message-id/405345F7.7080803@zeut.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: matthew@zeut.net, mail@joeconway.com, tgl@sss.pgh.pa.us
  Subject: Re: rapid degradation after postmaster restart
  In-Reply-To: <405345F7.7080803@zeut.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox