Re: pg_stats how-to? - Mailing list pgsql-performance

From Adam Tauno Williams
Subject Re: pg_stats how-to?
Date
Msg-id 1179107082.4558.4.camel@aleph.whitemice.org
Whole thread Raw
In response to pg_stats how-to?  (Yudhvir Singh Sidhu <ysidhu@gmail.com>)
List pgsql-performance
> Anyone know of a pg_stats howto? I'd appreciate any direction.

Let me know if you find one! :)

It isn't a HOWTO,  but I have collected some notes regarding the
performance views in a document -
http://docs.opengroupware.org/Members/whitemice/wmogag/file_view
 - see the chapter on PostgreSQL.  Hopefully this will continue to
expand.

The information is pretty scattered [ coming from a DB2 / Informix
background there there are specific performance guide],  try -
http://book.itzero.com/read/others/0508/Sams.PostgreSQL.2nd.Edition.Jul.2005_html/0672327562/ch04lev1sec2.html
http://www.postgresql.org/docs/8.0/interactive/monitoring-stats.html

Also just trolling on this list is useful.

--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org


pgsql-performance by date:

Previous
From: Yudhvir Singh Sidhu
Date:
Subject: pg_stats how-to?
Next
From: Richard Huxton
Date:
Subject: Re: 500 requests per second