| From: | jim(at)reptiles(dot)org (Jim Mercer) |
|---|---|
| To: | mirko(dot)kaffka(at)interface-business(dot)de |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] vacuum fails |
| Date: | 1999-06-14 09:39:05 |
| Message-ID: | m10tTCr-00080YC@mailbox.reptiles.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> we are using PostgreSQL 6.4.2 under FreeBSD 2.2.8.
> At a customers site we start vacuum nightly and for almost two weeks it
> has always run successfully. Now it fails and a 'vacuum verbose', run
blow away anything that can be re-created, or not needed (ie. indexes and
temp tables).
then vacuum again, rebuild indexes and away you go.
works for me.
--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1999-06-14 10:10:01 | Re: [GENERAL] Re: [HACKERS] postgres processes |
| Previous Message | Mirko Kaffka | 1999-06-14 08:51:18 | vacuum fails |