Re: [GENERAL][ADMIN]data fragmentation

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