Postgres Pro
Downloads
Home   >   mailing lists

Re: Unnecessary scan on a partial index slows down query dramatically - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Unnecessary scan on a partial index slows down query dramatically
Date
Msg-id 20080425163933.GF19447@crankycanuck.ca
Whole thread Raw
In response to Re: Unnecessary scan on a partial index slows down query dramatically  ("Jimmy Choi" <yhjchoi@gmail.com>)
List pgsql-general
Tree view 
On Fri, Apr 25, 2008 at 12:29:48PM -0400, Jimmy Choi wrote:
> Thanks. I'm not really in a position to upgrade at the moment.

You know that an upgrade of 8.1 to the latest is not a dump and restore, and
that running an older stability-and-security release of the software is
probably more dangerous than the upgrade itself, right?  (What you're doing
is akin to refusing to upgrade your production operating system to the
latest patchlevel.)

A

pgsql-general by date:

Previous
From: "Jimmy Choi"
Date:
Subject: Re: Unnecessary scan on a partial index slows down query dramatically
Next
From: Tom Lane
Date:
Subject: Re: Unnecessary scan on a partial index slows down query dramatically