From: Stephen Frost <sfrost@snowman.net>
To: Alex Turner <armtuk@gmail.com>
Cc: Alvaro Nunes Melo <al_nunes@atua.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware upgraded but performance still ain't good enough
Date: Tue, 8 Aug 2006 08:14:35 -0400
Message-ID: <20060808121435.GM20016@kenobi.snowman.net> (raw)
In-Reply-To: <33c6269f0608072333o67ab6adei29095091718901dc@mail.gmail.com>
References: <44D7B958.6030004@atua.com.br>
<33c6269f0608072333o67ab6adei29095091718901dc@mail.gmail.com>
Alvaro,
* Alex Turner (armtuk@gmail.com) wrote:
> The other thing is you will probably want to turn on stats in postgres to
> figure out which queries are the bad ones (does anyone have good docs posted
> for this?). Once you have identified the bad queries, you can explain
> analyze them, and figure out why they suck.
Given your position, this might be the best approach to take to find
some 'low-hanging fruit'. Do you have queries which are complex in some
way? Do you have many long-open transactions? If you're doing more
than simple queries then you may want to explain analyze the more
complex ones and try to speed them up. If you run into trouble
understanding the output or how to improve it then post it here (with as
much info as you can, schema definitions, the query, the explain analyze
results, etc) and we can help.
top/iostat/vmstat are very useful tools too and can help with hardware
decisions but you probably want to review your queries and make sure the
database is performing as best it can with the setup you have today
before throwing more hardware at it.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 188B) download
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: sfrost@snowman.net, armtuk@gmail.com, al_nunes@atua.com.br
Subject: Re: Hardware upgraded but performance still ain't good enough
In-Reply-To: <20060808121435.GM20016@kenobi.snowman.net>
* 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