From: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
---|---|
To: | reina(at)nsi(dot)edu, "pgsql-admin(at)postgreSQL(dot)org" <pgsql-admin(at)postgreSQL(dot)org> |
Subject: | Vacuum command |
Date: | 1998-12-10 17:54:54 |
Message-ID: | 36700AED.8662DC2A@nsi.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I've had trouble in the past with the vacuum command taking a long time
to complete. This past vacuum went for 5 days before I CTRL-C'd it. I'm
wondering if there is a bug.
I have PostgreSQL 6.3.2 on a Red Hat 5.1 system (PII/400 MHz, 256 Meg
RAM, 512 Meg Swap, 18 Gig Hard Ultra-wide SCSI Drive). The database
consists of about 30 tables and is 1.2 Gig in total size.
When I ran 'vacuum verbose analyze' the last time, the vacuum kept
working for 5 days until I killed it. I had no other programs running on
the system at the time. Also, I noticed that although 'top' showed that
the vacuum was using 98% of the system resources, the harddrive activity
was quiet during that 5 day period (as if nothing was actually
happening).
However, I then tried 'vacuum verbose analyze table_name' to vacuum just
one table at a time. When I did it one table at a time, I was able to
vacuum all 30 tables in less than 1 day.
I know that others have had there run in with long vacuums. I am
wondering whether there is a bug when the vacuum switches from one table
to the next?
-Tony
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-12-10 21:01:46 | Re: [ADMIN] Vacuum command |
Previous Message | Chris Williams | 1998-12-10 14:20:29 | Vacuum error |