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

Re: Poor performance - fixed by restart

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Wilson <petew(at)yellowhawk(dot)co(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance - fixed by restart
Date: 2006-06-22 16:24:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Peter Wilson <petew(at)yellowhawk(dot)co(dot)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

In response to

pgsql-performance by date

Next:From: David WheelerDate: 2006-06-22 18:11:36
Subject: Re: Performance of DOMAINs
Previous:From: Tom LaneDate: 2006-06-22 16:19:52
Subject: Re: Tuning New Server (slow function)

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