On Fri, Dec 12, 2003 at 09:59:23AM +0530, Somasekhar Bangalore wrote: > Hi, > > I too had the same problem; There was one query which used to take a > very long time. What I did was, I took a backup of the whole database. > Reinstalled postgres on a different mount point and restored the data > back into the new database. Now my queries are running faster. Try it. > All the very best.
You could instead apply CLUSTER to the affected tables. (I'm assuming you already apply VACUUM periodically and REINDEX as appropiate) -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Everybody understands Mickey Mouse. Few understand Hermann Hesse. Hardly anybody understands Einstein. And nobody understands Emperor Norton." ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match