On Sun, Nov 16, 2008 at 06:05:40AM +0800, Phoenix Kiula wrote:
> How long should cluster take on a db that's about 5.5GB in size? Is it
> worth doing on a production db? The db is running fast now anyway, so
> the only reason I am even thinking about this is because of the
> results of a VACUUM ANA
Thanks Scott. Could be my I/O as I am on 15k Raptor SATA drives with
RAID 1 only.
Anyway, reindexing happened fast (12 minutes) and things are now humming along.
How long should cluster take on a db that's about 5.5GB in size? Is it
worth doing on a production db? The db is running fast now anywa
On Sat, Nov 15, 2008 at 2:36 PM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> Hi.
>
> Per this thread:
> http://archives.postgresql.org/pgsql-general/2008-11/msg00608.php -- I
> think I understood that the time had come for my db to have a VACUUM
> FULL. (Regular autovacuum etc is working)
>
> I know
Hi.
Per this thread:
http://archives.postgresql.org/pgsql-general/2008-11/msg00608.php -- I
think I understood that the time had come for my db to have a VACUUM
FULL. (Regular autovacuum etc is working)
I know a full vacuum is slow. A simple google search had suggested so.
But I had no idea it w
