From: Tom Lane <tgl@sss.pgh.pa.us>
To: kaloyan@digsys.bg
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow query after upgrade from 8.2 to 8.4
Date: Thu, 08 Dec 2011 22:28:15 -0500
Message-ID: <14557.1323401295@sss.pgh.pa.us> (raw)
In-Reply-To: <4EE0F3F4.8040909@digsys.bg>
References: <4EE0F3F4.8040909@digsys.bg>
Kaloyan Iliev Iliev <kaloyan@digsys.bg> writes:
> We recently upgrade our server from PG8.2 to 8.4.
> ...
> Here I will post explain analyze. If you think it is necessary I will
> post the exact query:
> http://explain.depesz.com/s/J0O
Yeah, you need to show the query. It looks like the performance problem
is stemming from a lot of subselects, but it's not clear why 8.4 would
be handling those worse than 8.2.
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, kaloyan@digsys.bg
Subject: Re: Slow query after upgrade from 8.2 to 8.4
In-Reply-To: <14557.1323401295@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