From: Kevin Grittner <kgrittn@mail.com>
To: "Niels Kristian Schjødt" <nielskristian@autouncle.com>
To: sthomas@optionshouse.com
Cc: Willem Leenen <willem_leenen@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimize update query
Date: Thu, 29 Nov 2012 20:24:26 -0500
Message-ID: <20121130012426.69300@gmx.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Niels Kristian Schjødt wrote:
> Okay, now I'm done the updating as described above. I did the
> postgres.conf changes. I did the kernel changes, i added two
> SSD's in a software RAID1 where the pg_xlog is now located -
> unfortunately the the picture is still the same :-(
You said before that you were seeing high disk wait numbers. Now it
is zero accourding to your disk utilization graph. That sounds like
a change to me.
> When the database is under "heavy" load, there is almost no
> improvement to see in the performance compared to before the
> changes.
In client-visible response time and throughput, I assume, not
resource usage numbers?
> A lot of both read and writes takes more than a 1000 times as
> long as they usually do, under "lighter" overall load.
As an odd coincidence, you showed your max_connections setting to
be 1000.
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
-Kevin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@mail.com, nielskristian@autouncle.com, sthomas@optionshouse.com, willem_leenen@hotmail.com
Subject: Re: Optimize update query
In-Reply-To: <20121130012426.69300@gmx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox