Re: BUG #1552: massive performance hit between 7.4 and 8.0.1

From: Tom Lane
Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Date: ,
Msg-id: 23228.1111761669@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Simon Riggs)
List: pgsql-bugs

Tree view

BUG #1552: massive performance hit between 7.4 and 8.0.1  ("Brian O'Reilly", )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Josh Berkus, )
  Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Josh Berkus, )
   Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Tom Lane, )
  Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Brian O'Reilly, )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Keith Browne, )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Simon Riggs, )
  Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Keith Browne, )
   Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Simon Riggs, )
    Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Tom Lane, )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Andrew - Supernews, )
  Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Tom Lane, )
   Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Keith Browne, )
    Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Tom Lane, )
     Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Tom Lane, )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Andrew - Supernews, )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Andrew - Supernews, )
 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1  (Zeki, )

Simon Riggs <> 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


pgsql-bugs by date:

From: Tom Lane
Date:
Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
From: Patrick Clery
Date:
Subject: Strange behavior for boolean predicates and partial indexes