Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group