Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Unnecessary scan on a partial index slows down query dramatically
Date
Msg-id 21102.1209141833@sss.pgh.pa.us
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 
"Jimmy Choi" <yhjchoi@gmail.com> writes:
> Thanks. I'm not really in a position to upgrade at the moment.

Why not?  A minor version update doesn't take much more than stop the
server, install new binaries, start the server.

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Unnecessary scan on a partial index slows down query dramatically
Next
From: Oleg Bartunov
Date:
Subject: Re: Full Text Search