Are you running a lot of full table updates? On Thu, Jul 19, 2012 at 9: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? > > regards, > Felix > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- To understand recursion, one must first understand recursion. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
