From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Keith Browne <tuxedo@deepsky.com>
Cc: pgsql-bugs@postgresql.org, "Brian O'Reilly" <fade@deepsky.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Date: Fri, 25 Mar 2005 09:41:09 -0500
Message-ID: <23228.1111761669@sss.pgh.pa.us> (raw)
In-Reply-To: <1111745917.11750.713.camel@localhost.localdomain>
References: <20050318232102.08FA0F0E5D@svr2.postgresql.org>
<1111567230.11750.596.camel@localhost.localdomain>
<4241C1DF.2020000@deepsky.com>
<1111745917.11750.713.camel@localhost.localdomain>
Simon Riggs <simon@2ndquadrant.com> writes:
> I think we should spawn a TODO item from this:
> * Coerce FK lookups to always use an available index
No, we aren't doing that.
The correct TODO item is "Replan cached plans when table size has
changed a lot" which of course depends on having a framework to do
replanning at all. I intend to take a look at that once Neil has
created such a framework ...
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, simon@2ndquadrant.com, tuxedo@deepsky.com, fade@deepsky.com
Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
In-Reply-To: <23228.1111761669@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