Postgres Pro
Downloads
Home   >   mailing lists

Re: One query run twice in parallel results in huge performance decrease - Mailing list pgsql-performance

From Jan Michel
Subject Re: One query run twice in parallel results in huge performance decrease
Date
Msg-id 5299C68B.2060800@mueschelsoft.de
Whole thread Raw
In response to Re: One query run twice in parallel results in huge performance decrease  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: One query run twice in parallel results in huge performance decrease
Next
From: Hengky Liwandouw
Date:
Subject: Speed up the query