pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedA guide/tutorial to performance monitoring and tuning
8+ messages / 7 participants
[nested] [flat]
* A guide/tutorial to performance monitoring and tuning
@ 2008-06-27 14:23 Nikhil G. Daddikar <ngd@celoxis.com>
0 siblings, 3 replies; 8+ messages in thread
From: Nikhil G. Daddikar @ 2008-06-27 14:23 UTC (permalink / raw)
To: pgsql-performance
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?
Thanks.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-06-27 15:37 Andreas Kretschmer <akretschmer@spamfence.net>
parent: Nikhil G. Daddikar <ngd@celoxis.com>
2 siblings, 0 replies; 8+ messages in thread
From: Andreas Kretschmer @ 2008-06-27 15:37 UTC (permalink / raw)
To: pgsql-performance
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°
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-06-27 17:21 Scott Marlowe <scott.marlowe@gmail.com>
parent: Nikhil G. Daddikar <ngd@celoxis.com>
2 siblings, 1 reply; 8+ messages in thread
From: Scott Marlowe @ 2008-06-27 17:21 UTC (permalink / raw)
To: Nikhil G. Daddikar <ngd@celoxis.com>; +Cc: pgsql-performance
On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar <ngd@celoxis.com> 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-06-29 18:59 Greg Smith <gsmith@gregsmith.com>
parent: Nikhil G. Daddikar <ngd@celoxis.com>
2 siblings, 1 reply; 8+ messages in thread
From: Greg Smith @ 2008-06-29 18:59 UTC (permalink / raw)
To: Nikhil G. Daddikar <ngd@celoxis.com>; +Cc: pgsql-performance
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 gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-06-30 13:54 Cédric Villemain <cedric.villemain@dalibo.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Cédric Villemain @ 2008-06-30 13:54 UTC (permalink / raw)
To: pgsql-performance; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; Nikhil G. Daddikar <ngd@celoxis.com>
Le Friday 27 June 2008, Scott Marlowe a écrit :
> On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar <ngd@celoxis.com> 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
Attachments:
signature.asc (application/pgp-signature, 196B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-07-21 21:27 Francisco Reyes <lists@stringsutils.com>
parent: Greg Smith <gsmith@gregsmith.com>
0 siblings, 1 reply; 8+ messages in thread
From: Francisco Reyes @ 2008-07-21 21:27 UTC (permalink / raw)
To: Greg Smith <gsmith@gregsmith.com>; +Cc: pgsql-performance
On 2:59 pm 06/29/08 Greg Smith <gsmith@gregsmith.com> 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?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-07-22 05:24 Greg Smith <gsmith@gregsmith.com>
parent: Francisco Reyes <lists@stringsutils.com>
0 siblings, 1 reply; 8+ messages in thread
From: Greg Smith @ 2008-07-22 05:24 UTC (permalink / raw)
To: Francisco Reyes <lists@stringsutils.com>; +Cc: pgsql-performance
On Mon, 21 Jul 2008, Francisco Reyes wrote:
> On 2:59 pm 06/29/08 Greg Smith <gsmith@gregsmith.com> 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 gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: A guide/tutorial to performance monitoring and tuning
@ 2008-07-28 20:17 Mark Wong <markwkm@gmail.com>
parent: Greg Smith <gsmith@gregsmith.com>
0 siblings, 0 replies; 8+ messages in thread
From: Mark Wong @ 2008-07-28 20:17 UTC (permalink / raw)
To: Francisco Reyes <lists@stringsutils.com>; +Cc: pgsql-performance@postgresql.org, "Greg Smith" <gsmith@gregsmith.com>
On Mon, Jul 21, 2008 at 10:24 PM, Greg Smith <gsmith@gregsmith.com> wrote:
> On Mon, 21 Jul 2008, Francisco Reyes wrote:
>
>> On 2:59 pm 06/29/08 Greg Smith <gsmith@gregsmith.com> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2008-07-28 20:17 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-27 14:23 A guide/tutorial to performance monitoring and tuning Nikhil G. Daddikar <ngd@celoxis.com>
2008-06-27 15:37 ` Andreas Kretschmer <akretschmer@spamfence.net>
2008-06-27 17:21 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-06-30 13:54 ` Cédric Villemain <cedric.villemain@dalibo.com>
2008-06-29 18:59 ` Greg Smith <gsmith@gregsmith.com>
2008-07-21 21:27 ` Francisco Reyes <lists@stringsutils.com>
2008-07-22 05:24 ` Greg Smith <gsmith@gregsmith.com>
2008-07-28 20:17 ` Mark Wong <markwkm@gmail.com>
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