On Tue, Dec 16, 2003 at 10:29:20PM +0000, Jaime Casanova wrote: > >On Fri, Dec 12, 2003 at 09:59:23AM +0530, Somasekhar Bangalore wrote:
> >>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) > > What does CLUSTER does, and how can i use it? Everything You Always Wanted To Know About CLUSTER http://www.postgresql.org/docs/7.4/static/sql-cluster.html -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "El que vive para el futuro es un iluso, y el que vive para el pasado, un imbécil" (Luis Adler, "Los tripulantes de la noche") ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
