Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Max Williams" <Max(dot)Williams(at)mflow(dot)com>, "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Date: 2010-06-09 11:35:42
Message-ID: op.vd06hsoueorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance


Can you give the config params for those :

fsync =
synchronous_commit =
wal_sync_method =

Also, some "vmstat 1" output during the runs would be interesting.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2010-06-09 11:43:42 Re: Invalid YAML output from EXPLAIN
Previous Message Robert Haas 2010-06-09 11:32:29 Re: Invalid YAML output from EXPLAIN

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-06-09 19:47:55 Re: No hash join across partitioned tables?
Previous Message Max Williams 2010-06-09 10:56:16 Large (almost 50%!) performance drop after upgrading to 8.4.4?