Re: Slow Query on Postgres 8.2

From: "Dave Dutcher" <dave(at)tridecap(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow Query on Postgres 8.2
Date: 2007-01-08 18:59:14
Message-ID: 012601c73357$1736ff00$8300a8c0@tridecap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
>
> [ fools around with it for awhile... ] I think this is already fixed
> for 8.2.1. Note the costs of the two related index scans:

I installed 8.2.1 this morning and it works much better. The query that was
taking 3411.429ms on 8.2.0 now takes 9.3ms. Thanks for your help.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steven Flatt 2007-01-08 20:02:24 Re: table partioning performance
Previous Message Bruce Momjian 2007-01-08 18:09:16 Re: High update activity, PostgreSQL vs BigDBMS