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

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: leaf_yxj <leaf_yxj(at)163(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-17 19:02:41
Message-ID: 4FB54B51.5070005@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Mudd 2012-05-17 19:10:27 Replication recovery?
Previous Message leaf_yxj 2012-05-17 18:54:06 How to debug the performance issues via which system catalog.Thanks.