From: | leaf_yxj <leaf_yxj(at)163(dot)com> |
---|---|
To: | 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:51 |
Message-ID: | 5d5643fd.2693a.1376038ca3d.Coremail.leaf_yxj@163.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Steve.
At 2012-05-18 03:04:02,"Steve Crawford [via PostgreSQL]" <ml-node+s1045698n5709069h81(at)n5(dot)nabble(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
--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/How-to-debug-the-performance-issues-via-which-system-catalog-Thanks-tp5709065p5709069.html
To unsubscribe from How to debug the performance issues via which system catalog.Thanks., click here.
NAML
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-debug-the-performance-issues-via-which-system-catalog-Thanks-tp5709065p5709115.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | leaf_yxj | 2012-05-18 13:54:22 | Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks. |
Previous Message | yxj | 2012-05-18 13:52:06 | Re: How to debug the performance issues via which system catalog.Thanks. |