Hi Steve,
This is a very good website. We use the postgresql 8.2. there may be a little different. It's very useful to me.
Thanks.
Regards.
Grace
At 2012-05-18 03:02:41,"Steve Crawford" <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote: >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
