From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Steve Poe <spoe@sfnet.cc>
Subject: Re: Ideal disk setup for Postgresql 7.4?
Date: Thu, 27 Jan 2005 08:56:03 -0800
Message-ID: <200501270856.03632.josh@agliodbs.com> (raw)
In-Reply-To: <41F82CA2.5070604@sfnet.cc>
References: <41F63424.1060904@sfnet.cc>
<200501261849.15176.josh@agliodbs.com>
<41F82CA2.5070604@sfnet.cc>
Steve,
> You mentioned earlier that to get around the CS bug, avoid the query
> structures which trigger it. Dumb question: How do you isolate this?
In real terms, it's generally triggered by a query joining against a very
large table requiring a seq scan.
You can probably find the "bad queries" just by using PQA, and looking for
select, delete and update queries which last over 60 seconds.
> Is there a way in a Postgresql query to only look at 1 processor only in
> a dual-CPU setup?
That would be an OS question. I personally can't see how.
> Any likelyhood this CS storm will be understood in the next couple months?
It's well understood. See the archives of this list. The problem is that
implementing the solution is very, very hard -- 100+ hours from a top-notch
programmer. I'm still hoping to find a corporate sponsor for the issue ...
--
Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, spoe@sfnet.cc
Subject: Re: Ideal disk setup for Postgresql 7.4?
In-Reply-To: <200501270856.03632.josh@agliodbs.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