Hi, I am running a 9.1 server at Ubuntu. When I upgraded to the current version
I did a pg_dump followed by pg_restore and found that the db was much faster.
But slowed down again after two days. I did the dump-restore again and could
now
compare the two (actually identical) databases. This is
Interesting.
Thanks for the work-around.
Regards,
Nick
-Original Message-
From: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: donderdag 19 juli 2012 0:36
To: Nick Hofstede
Cc: pgsql-performance@postgresql.org
Subject:
On 07/19/2012 07:33 AM, Felix Scheicher wrote:
Hi, I am running a 9.1 server at Ubuntu. When I upgraded to the current version
I did a pg_dump followed by pg_restore and found that the db was much faster.
But slowed down again after two days. I did the dump-restore again and could now
compare
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
On 07/19/2012 11:13 AM, Felix Scheicher 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,
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!
Are you running a lot of full table updates?
On Thu, Jul 19, 2012 at 9: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
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
Hi all,
We have put some deferred constraints (some initially immediate, some
initially deferred) into our database for testing with our applications.
I haven't seen any noticeable loss in performance, but I am not sure I can
properly simulate our full production environment load levels in my