Re: queries are fast after dump->restore but slow again after some days dispite vacuum

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: mandavi <mandavi(at)web(dot)de>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Date: 2012-07-20 07:10:23
Message-ID: 5009045F.8020502@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>> Are you running a lot of full table updates?
> If you mean updates which are applied on every or almost every row of
> the table - yes, it happens with two rather small tables of max. 10
> 000 rows. But they are both not touched by the query with this big
> performance difference.
I'm not an expert, but would it help to change fillfactor to about 45%?
I'm just guessing that full table updates with fillfactor=45% could
store the rows on the same page. Maybe I'm wrong.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ioannis Anagnostopoulos 2012-07-20 21:19:22 A very long running query....
Previous Message mark 2012-07-20 02:27:38 Deferred constraints performance impact ?