Thread: How to debug the performance issues via which system catalog.Thanks.
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-system-catalog-Thanks-tp5709065.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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
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@pinpointresearch.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
Thanks Steve.
At 2012-05-18 03:04:02,"Steve Crawford [via PostgreSQL]" <[hidden email]> 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-generalIf 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.htmlTo unsubscribe from How to debug the performance issues via which system catalog.Thanks., click here.
NAML
View this message in context: Re:Re: How to debug the performance issues via which system catalog.Thanks.
Sent from the PostgreSQL - general mailing list archive at Nabble.com.