Re: Parallel Select query performance and shared buffers

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: Metin Doslu <metin(at)citusdata(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Parallel Select query performance and shared buffers
Date: 2013-12-10 20:20:11
Message-ID: CAHyXU0yjqFwORNKAYyA7parh=jrecf94FwiNS_JWvu2RBy3+YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Dec 10, 2013 at 2:06 PM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> On Tue, Dec 10, 2013 at 5:03 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>> Also, can I see a typical 'top' during poor scaling count(*) activity?
>> In particular, what's sys cpu%. I'm guessing it's non trivial.
>
>
> There was another thread, this seems like a mistaken double post or
> something like that.
>
> In that other thread, he did provide that, and it was ~40% sy.

oops. disregard, I'll respond over there.

merlin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2013-12-10 20:40:09 Re: Explain analyze time overhead
Previous Message Claudio Freire 2013-12-10 20:06:11 Re: Parallel Select query performance and shared buffers