Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VmiN0-0000BZ-4M for pgsql-performance@arkaria.postgresql.org; Sat, 30 Nov 2013 11:05:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VmiMz-0006T1-7d for pgsql-performance@arkaria.postgresql.org; Sat, 30 Nov 2013 11:05:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VmiMy-0006Su-3k for pgsql-performance@postgresql.org; Sat, 30 Nov 2013 11:05:52 +0000 Received: from dd20832.kasserver.com ([85.13.140.227]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VmiMu-0001FI-U2 for pgsql-performance@postgresql.org; Sat, 30 Nov 2013 11:05:51 +0000 Received: from [192.168.1.3] (p4FDC01D7.dip0.t-ipconnect.de [79.220.1.215]) by dd20832.kasserver.com (Postfix) with ESMTPA id D69451CA0CD7; Sat, 30 Nov 2013 12:05:46 +0100 (CET) Message-ID: <5299C68B.2060800@mueschelsoft.de> Date: Sat, 30 Nov 2013 12:05:47 +0100 From: Jan Michel User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1 MIME-Version: 1.0 To: Tom Lane CC: "pgsql-performance@postgresql.org" Subject: Re: One query run twice in parallel results in huge performance decrease References: <5299103F.1040307@mueschelsoft.de> <52991D59.9050100@mueschelsoft.de> <21793.1385768887@sss.pgh.pa.us> In-Reply-To: <21793.1385768887@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 30.11.2013 00:48, Tom Lane wrote: > Are you explicitly ANALYZE'ing the newly-built tables in your script, > or are you just trusting auto-analyze to get the job done? Hi Tom, there is an explicit analyze of the table being done between filling the table with values and running this query. I sketched the process of creating and filling the table here: http://etherpad.netluchs.de/pgquery Jan -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance