From: Tom Lane <tgl@sss.pgh.pa.us>
To: miguel.silva@tactis.pt
Cc: pgsql-performance@postgresql.org
Subject: Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
Date: Fri, 30 Dec 2011 12:40:19 -0500
Message-ID: <19327.1325266819@sss.pgh.pa.us> (raw)
In-Reply-To: <4EFDE928.50807@tactis.pt>
References: <4EFDE928.50807@tactis.pt>
Miguel Silva <miguel.silva@tactis.pt> writes:
> But with postgresql version 9.0.5 (in version 9.0.4 all was fine), we
> noticed the program was taking longer to start. In fact, in some clients
> that had older hardware, it could take around 20 minutes when it usually
> takes only a few seconds. To make a long story short, the problem was
> traced and narrowed down to a single auto generated query. Here it is:
> "SELECT [ snip ]"
> ... Here are the explain analyzes.
> enable_material ON: http://explain.depesz.com/s/wen
> enable_material OFF: http://explain.depesz.com/s/Zaa
It doesn't really accomplish anything to post anonymized explain output
when you've already shown us the actual query, does it? Especially when
said query involves only the system catalogs and by no stretch of the
imagination could be thought to contain anything proprietary?
regards, tom lane
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: tgl@sss.pgh.pa.us, miguel.silva@tactis.pt
Subject: Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
In-Reply-To: <19327.1325266819@sss.pgh.pa.us>
* 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