On Mon, 22 Sep 2003, Hornyak Laszlo wrote:
> Hi all!
> We have a database on postgreSQL 6.2 and it is extremely slow, so we
> started vacuum on it. I know it locks the tables, so clients can not use
> it until the process is finished, but it is extremely slow on a 1.800.000
> record table and we don't know how to make it faster. Can anybody help me?
> It seems it is writing an index file, but it grows very slowly.
> I know we should use 7.3 at least, we are working on it, but we need to
> survive this day with 6.2 :(
In all honesty, it'd probably be faster to convert than to wait for that
vacuum to finish.
6.2 is like the model A of Postgresql versions.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2003-09-23 17:16:35|
|Subject: Re: pg_dump doesn't dump binary compatible casts |
|Previous:||From: Marko Karppinen||Date: 2003-09-23 16:51:53|
|Subject: Re: [GENERAL] Can't Build 7.3.4 on OS X |
pgsql-admin by date
|Next:||From: Priya G||Date: 2003-09-23 17:16:48|
|Subject: Re: help needed!!!|
|Previous:||From: scott.marlowe||Date: 2003-09-23 16:52:27|
|Subject: Re: steps to ensure referential integrity|