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
> 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.
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2012-07-19 16:17:12|
|Subject: Re: [PERFORM] DELETE vs TRUNCATE explanation|
|Previous:||From: Andrew Dunstan||Date: 2012-07-19 15:48:46|
|Subject: Re: queries are fast after dump->restore but slow again
after some days dispite vacuum|