Re: Query execution plan from 8.3 -> 8.4

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Brendan Hill <brendanh(at)jims(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query execution plan from 8.3 -> 8.4
Date: 2010-05-12 14:14:53
Message-ID: 20100512141453.GR21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Brendan,

* Brendan Hill (brendanh(at)jims(dot)net) wrote:
> Getting significantly lower performance on a specific query after upgrading
> from 8.3 -> 8.4 (windows). I'm not expecting a quick fix from the mail
> lists, but I would appreciate any indications as to where else I could look
> or what tools I could employ to investigae further. Details below.

For starters, this probably should go to -perform instead of -hackers,
and it would be much more useful to have EXPLAIN ANALYZE results rather
than just EXPLAIN.

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2010-05-12 14:29:13 Re: Query execution plan from 8.3 -> 8.4
Previous Message Stefan Kaltenbrunner 2010-05-12 14:03:31 Re: max_standby_delay considered harmful