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