Re: Simple query showing 270 hours of CPU time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Simple query showing 270 hours of CPU time
Date
Msg-id 11835.1184955146@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple query showing 270 hours of CPU time  (Dan Harris <fbsd@drivefaster.net>)
List pgsql-performance
Dan Harris <fbsd@drivefaster.net> writes:
> Since you mentioned the number of semops is distressingly high, does this
> indicate a tuning problem?

More like an old-version problem.  We've done a lot of work on
concurrent performance since 8.0.x, and most likely you are hitting
one of the bottlenecks that have been solved since then.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: User concurrency thresholding: where do I look?
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: User concurrency thresholding: where do I look?