Re: 8.1 -> 8.4 regression

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 8.1 -> 8.4 regression
Date: 2010-02-15 16:16:04
Message-ID: 8D572A50-01C7-464B-8D0D-FCF19C53BC9C@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 through were because of the size of the email.)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-02-15 16:41:43 Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Previous Message Kevin Grittner 2010-02-15 15:59:27 Re: 8.1 -> 8.4 regression