Re: [GENERAL] How to debug the performance issues via which system catalog.Thanks.

2012-05-18 Thread yxj
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" wrote: >On 05/17/2012 11:54 AM, leaf_yxj wrote: >> I know we can know the currenct activity via pg_s

Re: [GENERAL] How to debug the performance issues via which system catalog.Thanks.

2012-05-17 Thread Steve Crawford
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, num

[GENERAL] How to debug the performance issues via which system catalog.Thanks.

2012-05-17 Thread leaf_yxj
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 -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-debug-the-performance-issues-via-which-syste