Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange problem with an index. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Strange problem with an index.
Date
Msg-id 23886.1195161140@sss.pgh.pa.us
Whole thread Raw
In response to Strange problem with an index.  ("Blanco, Jose" <blancoj@umich.edu>)
List pgsql-bugs
Tree view 
"Blanco, Jose" <blancoj@umich.edu> writes:
> Well, this was running very slowly, so I droped the index and recreated
> it, and then it ran quickly.

Sounds like you had a bloated index.

> I'm running versin 7.3

Consider switching to something more modern --- 7.3 is vastly slower
than current releases.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Blanco, Jose"
Date:
Subject: Strange problem with an index.
Next
From: "Lance Andersen"
Date:
Subject: BUG #3751: Conversion error using PreparedStatement.setObject()