| From: | Tim Perdue <tperdue(at)valinux(dot)com> |
|---|---|
| To: | pgsql-hackers(at)hub(dot)org |
| Subject: | Eternal vacuuming.... |
| Date: | 2000-05-11 14:57:09 |
| Message-ID: | 391ACA45.849B4886@valinux.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I checked the changelog for 7.0 and it doesn't look like this is fixed
yet.
In 6.4.x and 6.5.x if you delete a large number of rows (say 100,000 -
1,000,000) then hit vacuum, the vacuum will run literally forever.
If you drop the indexes on the table, vacuuming takes only minutes, but
that's a pain in the neck.
This problem kept my site down for some 12 HOURS last nite:
24244 ? S 0:00 psql db_gotocity
24245 ? R 951:34 /usr/local/pgsql/bin/postgres localhost tim
db_gotocity
...before I finally killed the vacuum process, manually removed the
pg_vlock, dropped the indexes, then vacuumed again, and re-indexed.
Will this be fixed?
Tim
--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2000-05-11 14:58:10 | Re: Multibyte still broken |
| Previous Message | Bruce Momjian | 2000-05-11 14:47:06 | Re: Now 376175 lines of code |