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")

Tue, 16 Dec 2003 19:42:38 -0300
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: [GENERAL][ADMIN]data fragmentation