From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Wilson <petew@yellowhawk.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Poor performance - fixed by restart
Date: Thu, 22 Jun 2006 12:24:44 -0400
Message-ID: <766.1150993484@sss.pgh.pa.us> (raw)
In-Reply-To: <e7cjho$27q6$1@news.hub.org>
References: <e7cjho$27q6$1@news.hub.org>
Peter Wilson <petew@yellowhawk.co.uk> writes:
> I'd tweaked a couple of parameters in postgres.conf - the significant one I
> thought being random_page_cost, so I changed this back to default and did a
> 'service postgresql reload' - no difference, but I wasn't sure whether this
> could be changed via reload so I restarted Postgres.
> The restart fixed the problem. The 85 second insert time dropped back down to 5
> seconds!!!
Um, which parameters did you change *exactly*?
Also, depending on how you were submitting the queries, it's possible
that Postgres was using cached plans already made based on the old
settings. In that case the restart would've cleared the bad plans
(but starting a fresh connection would've been sufficient for that).
regards, tom lane
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: tgl@sss.pgh.pa.us, petew@yellowhawk.co.uk
Subject: Re: Poor performance - fixed by restart
In-Reply-To: <766.1150993484@sss.pgh.pa.us>
* 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