pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / 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