Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
On Mon, Jul 21, 2008 at 10:24 PM, Greg Smith <[EMAIL PROTECTED]> wrote: > On Mon, 21 Jul 2008, Francisco Reyes wrote: > >> On 2:59 pm 06/29/08 Greg Smith <[EMAIL PROTECTED]> wrote: >>> >>> Right now I'm working with a few other people to put together a more >>> straightforward single intro guide that should address some of the >>> vagueness you point out here, >> >> Was that ever completed? > > Not done yet; we're planning to have a first rev done in another couple of > weeks. The work in progress is at > http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and I'm due to > work out another set of improvements to that this week during OSCON. I'd also like to point out we're putting together some data revolving about software raid, hardware raid, volume management, and filesystem performance on a system donated by HP here: http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide Note that it's also a living guide and we've haven't started covering some of the things I just mentioned. Regards, Mark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
On Mon, 21 Jul 2008, Francisco Reyes wrote: On 2:59 pm 06/29/08 Greg Smith <[EMAIL PROTECTED]> wrote: Right now I'm working with a few other people to put together a more straightforward single intro guide that should address some of the vagueness you point out here, Was that ever completed? Not done yet; we're planning to have a first rev done in another couple of weeks. The work in progress is at http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and I'm due to work out another set of improvements to that this week during OSCON. -- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
On 2:59 pm 06/29/08 Greg Smith <[EMAIL PROTECTED]> wrote: > Right now I'm working with a few other people to put together a more > straightforward single intro guide that should address some of the > vagueness you point out here, Was that ever completed? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
Le Friday 27 June 2008, Scott Marlowe a écrit : > On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar <[EMAIL PROTECTED]> wrote: > > 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? > > If you run nagios, lookup the pgsql nagios plugin. it's quite an > impressive little bit of code. http://bucardo.org/check_postgres/ but it only supervise afaik you can collect data and monitor with munin : http://pgfoundry.org/projects/muninpgplugins/ -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org signature.asc Description: This is a digitally signed message part.
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
On Fri, 27 Jun 2008, Nikhil G. Daddikar wrote: 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". That's because it does depend. I collect up the best of resources out there and keep track of them at http://wiki.postgresql.org/wiki/Performance_Optimization so if you didn't find that yet there's probably some good ones you missed. Right now I'm working with a few other people to put together a more straightforward single intro guide that should address some of the vagueness you point out here, but that's still a few weeks away from being ready. Monitoring performance isn't really covered in any of this though. Right now the best simple solution out there is probably Nagios with the PostgreSQL plug-in. -- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar <[EMAIL PROTECTED]> wrote: > 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? If you run nagios, lookup the pgsql nagios plugin. it's quite an impressive little bit of code. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning
Nikhil G. Daddikar <[EMAIL PROTECTED]> 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° -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance