On Thu, Jul 19, 2012 at 8:13 AM, Felix Scheicher <mandavi@xxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
