From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-performance@postgresql.org
Subject: Re: A guide/tutorial to performance monitoring and tuning
Date: Fri, 27 Jun 2008 17:37:49 +0200
Message-ID: <20080627153749.GA11421@tux> (raw)
In-Reply-To: <4864F7C7.3020901@celoxis.com>
References: <4864F7C7.3020901@celoxis.com>
Nikhil G. Daddikar <ngd@celoxis.com> schrieb:
> Hello,
>
> I have been searching on the net on how to tune and monitor performance
> of my postgresql server but not met with success. A lot of information
> is vague and most often then not the answer is "it depends". Can anyone
> of you refer me a nice guide or tutorial on this?
Depends ;-)
You can log queries with an execution time more than N milliseconds via
log_min_duration. You can analyse the log with tools like pgfouine. And
you can analyse such queries with EXPLAIN ANALYSE.
But, i don't know your current problem, that's why my answer are a little
bit vague...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
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: akretschmer@spamfence.net
Subject: Re: A guide/tutorial to performance monitoring and tuning
In-Reply-To: <20080627153749.GA11421@tux>
* 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