Re: Unnecessary scan on a partial index slows down query dramatically

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unnecessary scan on a partial index slows down query dramatically
Date: 2008-04-25 16:39:33
Message-ID: 20080425163933.GF19447@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-25 16:43:53 Re: Unnecessary scan on a partial index slows down query dramatically
Previous Message Jimmy Choi 2008-04-25 16:29:48 Re: Unnecessary scan on a partial index slows down query dramatically