From: | yxj <leaf_yxj(at)163(dot)com> |
---|---|
To: | "Steve Crawford" <scrawford(at)pinpointresearch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to debug the performance issues via which system catalog.Thanks. |
Date: | 2012-05-18 13:52:06 |
Message-ID: | 5454c597.26923.13760383aed.Coremail.leaf_yxj@163.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)pinpointresearch(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | leaf_yxj | 2012-05-18 13:52:51 | Re: How to debug the performance issues via which system catalog.Thanks. |
Previous Message | yxj | 2012-05-18 13:47:13 | Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks. |