Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoGo9-0006zS-7i for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 18:04:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VoGo8-00014M-Fc for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 18:04:20 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoGo4-0000yD-9z; Wed, 04 Dec 2013 18:04:16 +0000 Received: from moutng.kundenserver.de ([212.227.17.10]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoGo1-0007lc-Gc; Wed, 04 Dec 2013 18:04:15 +0000 Received: from anarazel.de (p5DDC5FC6.dip0.t-ipconnect.de [93.220.95.198]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0M3fOP-1VWSwH052n-00rAKd; Wed, 04 Dec 2013 19:04:12 +0100 Received: by anarazel.de (Postfix, from userid 1000) id 5FE4C1019EF; Wed, 4 Dec 2013 19:04:11 +0100 (CET) Date: Wed, 4 Dec 2013 19:04:11 +0100 From: Andres Freund To: Claudio Freire Cc: Metin Doslu , Amit Kapila , pgsql-hackers , postgres performance list Subject: Re: Parallel Select query performance and shared buffers Message-ID: <20131204180411.GE7383@awork2.anarazel.de> References: <20131204163350.GA5756@awork2.anarazel.de> <20131204165410.GA7286@awork2.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Provags-ID: V02:K0:EiCdYVZsDJShyb2tqTZULKHO02z9jAE5NMRTHa0Wx97 A+ZsF4e+q9lsXVMnDbFCvs8/Ncu7CliMtuF++wqhJWQVta5xrV QJ9jKndNq5MZqR5wx+Yamn36m9sECbYlvqRQOC5nfcyM/VjC8g M8ZKztgh5Y8x0DAORA2QdS3+WLofpaqHhazB4H0xsPvyfzmbB2 /SuXImxlCj4aqAY6OLCd4i+wU0cKvWJ0B7SbH9yh5ijNLm4llY HrB0V1/rT3Ww/rOQ3pC+ftvZmH6IUVzeErVJ4ZglJ3278Ewn0f YS4MetLMgBs54XetXAGAlucsIrA5JopIHNvlCsjxgOng1itH/D XQigwuNgjwjBiSh4qMcx6WQSvrKIpOFu5H5HEvOlV X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2013-12-04 16:00:40 -0200, Claudio Freire wrote: > On Wed, Dec 4, 2013 at 1:54 PM, Andres Freund 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