Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL][HACKERS]data fragmentation

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Somasekhar Bangalore <sbangalore(at)zensutra(dot)com>
Cc: Jaime Casanova <el_vigia_ec(at)hotmail(dot)com>,pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org,pgsql-admin(at)postgresql(dot)org, K Harikumar <kharikumar(at)zensutra(dot)com>,Anoop G <ganoop(at)zensutra(dot)com>, Sanjay Rathod <srathod(at)zensutra(dot)com>
Subject: Re: [GENERAL][HACKERS]data fragmentation
Date: 2003-12-16 22:03:14
Message-ID: 20031216220314.GE14503@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
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."

In response to

pgsql-hackers by date

Next:From: Neil ConwayDate: 2003-12-16 22:37:31
Subject: Re: [pgsql-hackers-win32] [PATCHES] fork/exec patch
Previous:From: Jon JensenDate: 2003-12-16 21:48:18
Subject: Re: Resurrecting pg_upgrade

pgsql-admin by date

Next:From: sachdevDate: 2003-12-17 04:02:31
Subject: Re: comparing with oracle
Previous:From: scott.marloweDate: 2003-12-16 21:05:19
Subject: Re: Postgresql on software RAID

pgsql-general by date

Next:From: Rick GiggerDate: 2003-12-16 22:58:27
Subject: Re: add column sillyness
Previous:From: Alvaro HerreraDate: 2003-12-16 22:01:16
Subject: Re: Strange permission problem regarding pg_settings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group