Re: CPU bound at 99%

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bryan Buecking" <buecking(at)gmail(dot)com>
Cc: "Erik Jones" <erik(at)myemma(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: CPU bound at 99%
Date: 2008-04-22 16:23:55
Message-ID: dcc563d10804220923k3fcce99dw79886f735db991b0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 22, 2008 at 10:10 AM, Bryan Buecking <buecking(at)gmail(dot)com> wrote:
>
> I agree, but the number of idle connections dont' seem to affect
> performace only memory usage. I'm trying to lessen the load of
> connection setup. But sounds like this tax is minimal?

Not entirely true. There are certain things that happen that require
one backend to notify ALL OTHER backends. when this happens a lot,
then the system will slow to a crawl.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-04-22 16:25:36 Re: CPU bound at 99%
Previous Message Bryan Buecking 2008-04-22 16:22:37 Re: CPU bound at 99%