>>> 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? >> 2012/7/19 Scott Marlowe <scott.marl...@gmail.com>: > Are you running a lot of full table updates?
If you mean updates which are applied on every or almost every row of the table - yes, it happens with two rather small tables of max. 10 000 rows. But they are both not touched by the query with this big performance difference. Regards, Felix -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
