Re: Finding bottleneck - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Finding bottleneck
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD167@Herge.rcsinc.local
Whole thread Raw
In response to Finding bottleneck  (Kari Lavikka <tuner@bdb.fi>)
List pgsql-performance
> That seems quite peculiar; AFAICS the pgstat code shouldn't be any
> slower than before.  At first I thought it might be because we'd
> increased PGSTAT_ACTIVITY_SIZE, but actually that happened before
> 8.0 release, so it shouldn't be a factor in this comparison.

Just FYI the last time I looked at stats was in the 8.0 beta period.

> Can anyone else confirm a larger penalty for stats_command_string in
> HEAD than in 8.0?  A self-contained test case would be nice too.

looking into it.

Merlin



pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: MemoryContextSwitchTo during table scan?
Next
From: John Mendenhall
Date:
Subject: Re: complex query performance assistance request