Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group