pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andres Freund <andres@2ndquadrant.com>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: Metin Doslu <metin@citusdata.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Parallel Select query performance and shared buffers
Date: Wed, 4 Dec 2013 19:04:11 +0100
Message-ID: <20131204180411.GE7383@awork2.anarazel.de> (raw)
In-Reply-To: <CAGTBQpb5_K-_YY96D-CRh=mKq6AQW45ztptV5akCNUuV7jxR_A@mail.gmail.com>
References: <CAL1dPcfZJFO2gr+53mU14VrrHxT-Bs6QOYgzQNV_VgxnkKUaZA@mail.gmail.com>
	<CAA4eK1+RaLg9dfici05QL_r=G5uZ3Zi=BGJ8C0pVCJ9o9V_s+A@mail.gmail.com>
	<CAGTBQpZCtDHhifv6m3EJrB5CZu3bnyqYHweM8-0G=cVm-n9V0A@mail.gmail.com>
	<CAL1dPce3Fe6nPwKwSe_2njOBHPp5qkLYHJzCBUqE-cfFGy9ctA@mail.gmail.com>
	<CAGTBQpbRNt7oK9Z9dJpN_ChV4TqBZpYD+634Zm1wg4NjC_Zx2w@mail.gmail.com>
	<20131204163350.GA5756@awork2.anarazel.de>
	<CAL1dPceswxJMRWR0DqoMas3be147o_Z-nW5siVMEdNBbod=cYA@mail.gmail.com>
	<20131204165410.GA7286@awork2.anarazel.de>
	<CAGTBQpb5_K-_YY96D-CRh=mKq6AQW45ztptV5akCNUuV7jxR_A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 2013-12-04 16:00:40 -0200, Claudio Freire wrote:
> On Wed, Dec 4, 2013 at 1:54 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> > All that time is spent in your virtualization solution. One thing to try
> > is to look on the host system, sometimes profiles there can be more
> > meaningful.
> 
> You cannot profile the host on EC2.

Didn't follow the thread from the start. So, this is EC2? Have you
checked, with a recent enough version of top or whatever, how much time
is reported as "stolen"?

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (37+ messages)  latest in thread

Message-ID: <20131204180411.GE7383@awork2.anarazel.de>
Permalink:  ../20131204180411.GE7383@awork2.anarazel.de/
Also on:    postgresql.org/message-id/20131204180411.GE7383@awork2.anarazel.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: andres@2ndquadrant.com, klaussfreire@gmail.com, metin@citusdata.com, amit.kapila16@gmail.com, pgsql-hackers@postgresql.org
  Subject: Re: Parallel Select query performance and shared buffers
  In-Reply-To: <20131204180411.GE7383@awork2.anarazel.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox