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

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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Felix Scheicher <mandavi(at)web(dot)de>
Cc: 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-19 16:12:08
Message-ID: CAMkU=1zC6qCJL+7o7mbxV9k1r39PO9u=Cba8h2F6VAY+6XDNBQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Jul 19, 2012 at 8:13 AM, Felix Scheicher <mandavi(at)web(dot)de> wrote:
> Andrew Dunstan <andrew <at> dunslane.net> writes:
>
>> Try running CLUSTER on the relevant tables and see if it makes a
>> difference. If it does you might want to look into using pg_reorg
>> periodically.
>
>
> That worked like a charm! Many thanks. But how comes, the queries are also fast
> after a restore without the cluster?

Probably fewer buffers needed to be touched.

Running "explain (analyze, buffers)" would give information on how
many buffers were touched.


Cheers,

Jeff

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2012-07-19 16:17:12
Subject: Re: [PERFORM] DELETE vs TRUNCATE explanation
Previous:From: Andrew DunstanDate: 2012-07-19 15:48:46
Subject: Re: queries are fast after dump->restore but slow again after some days dispite vacuum

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