Subject: Strange problem with an index.
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 11/15/2007 4:12:20 PM
"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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|