Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Query on Postgres 8.2 - Mailing list pgsql-performance

From Dave Dutcher
Subject Re: Slow Query on Postgres 8.2
Date
Msg-id 012601c73357$1736ff00$8300a8c0@tridecap.com
Whole thread Raw
In response to Re: Slow Query on Postgres 8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.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.

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: High update activity, PostgreSQL vs BigDBMS
Next
From: "Steven Flatt"
Date:
Subject: Re: table partioning performance