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)
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 Conway||Date: 2003-12-16 22:37:31|
|Subject: Re: [pgsql-hackers-win32] [PATCHES] fork/exec patch|
|Previous:||From: Jon Jensen||Date: 2003-12-16 21:48:18|
|Subject: Re: Resurrecting pg_upgrade|
pgsql-admin by date
|Next:||From: sachdev||Date: 2003-12-17 04:02:31|
|Subject: Re: comparing with oracle|
|Previous:||From: scott.marlowe||Date: 2003-12-16 21:05:19|
|Subject: Re: Postgresql on software RAID|
pgsql-general by date
|Next:||From: Rick Gigger||Date: 2003-12-16 22:58:27|
|Subject: Re: add column sillyness|
|Previous:||From: Alvaro Herrera||Date: 2003-12-16 22:01:16|
|Subject: Re: Strange permission problem regarding pg_settings|