Re: One query run twice in parallel results in huge performance decrease

From: Jan Michel <Jan(at)mueschelsoft(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: One query run twice in parallel results in huge performance decrease
Date: 2013-11-30 11:05:47
Message-ID: 5299C68B.2060800@mueschelsoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hengky Liwandouw 2013-12-01 06:21:05 Speed up the query
Previous Message Tom Lane 2013-11-29 23:48:07 Re: One query run twice in parallel results in huge performance decrease