Re: Simple query showing 270 hours of CPU time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Simple query showing 270 hours of CPU time
Date: 2007-07-20 18:12:26
Message-ID: 11835.1184955146@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dan Harris <fbsd(at)drivefaster(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jignesh K. Shah 2007-07-20 18:18:05 Re: User concurrency thresholding: where do I look?
Previous Message Jignesh K. Shah 2007-07-20 18:08:49 Re: User concurrency thresholding: where do I look?