On 05/17/2012 11:54 AM, leaf_yxj wrote:
I know we can know the currenct activity via pg_stat_activity. What's else
you guys use to debug.
And for some times back, how can we check the activities?
Thanks.
Grace
Performance is a complex enough issue to warrant its own mailing list
(CPU type, number of cores, OS, OS settings, PG configuration, disk
type/count/filesystem/raid-configuration and so on).
Greg Smith's "PostgreSQL 9.0 High Performance" is worth every penny.
While waiting for it to arrive, peruse the pages at
http://wiki.postgresql.org/wiki/Performance_Optimization
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
