Date: Tue, 8 Aug 2006 08:14:35 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Alex Turner <armtuk@gmail.com>
Cc: Alvaro Nunes Melo <al_nunes@atua.com.br>, pgsql-performance@postgresql.org
Subject: Re: Hardware upgraded but performance still ain't good enough
Message-ID: <20060808121435.GM20016@kenobi.snowman.net>
Mail-Followup-To: Alex Turner <armtuk@gmail.com>,
	Alvaro Nunes Melo <al_nunes@atua.com.br>,
	pgsql-performance@postgresql.org
References: <44D7B958.6030004@atua.com.br>
	<33c6269f0608072333o67ab6adei29095091718901dc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="Kpsb9uGLH42Key6t"
Content-Disposition: inline
In-Reply-To: <33c6269f0608072333o67ab6adei29095091718901dc@mail.gmail.com>
User-Agent: Mutt/1.5.11+cvs20060403


--Kpsb9uGLH42Key6t
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--Kpsb9uGLH42Key6t
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFE2IArrzgMPqB3kigRAlLGAJ4ySSrMSHf9B+LKcuXnkiv/QAWsDQCfddW9
r8t4/iE3AoaoQGfY1UGXPLk=
=BC8o
-----END PGP SIGNATURE-----

--Kpsb9uGLH42Key6t--