Re: 8.1 -> 8.4 regression - Mailing list pgsql-performance

From Ben Chobot
Subject Re: 8.1 -> 8.4 regression
Date
Msg-id 8D572A50-01C7-464B-8D0D-FCF19C53BC9C@silentmedia.com
Whole thread Raw
In response to Re: 8.1 -> 8.4 regression  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: 8.1 -> 8.4 regression
List pgsql-performance
On Feb 15, 2010, at 7:59 AM, Kevin Grittner wrote:

> Could you show the query, along with table definitions (including
> indexes)?

Oh, yeah, I suppose that would help. :)

http://wood.silentmedia.com/bench/query_and_definitions

(I'd paste them here for posterity but I speculate the reason my first few attempts to ask this question never went
throughwere because of the size of the email.) 

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: 8.1 -> 8.4 regression
Next
From: Robert Haas
Date:
Subject: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?