From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: A guide/tutorial to performance monitoring and tuning |
Date: | 2008-06-27 15:37:49 |
Message-ID: | 20080627153749.GA11421@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Nikhil G. Daddikar <ngd(at)celoxis(dot)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°
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-06-27 17:21:32 | Re: A guide/tutorial to performance monitoring and tuning |
Previous Message | Nikhil G. Daddikar | 2008-06-27 14:23:03 | A guide/tutorial to performance monitoring and tuning |