| From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: autovacuum and temporary tables |
| Date: | 2006-01-20 16:18:47 |
| Message-ID: | 1137773927.14451.27.camel@coppola.muc.ecircle.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
OK, I have an 8.0.almost 5 installation which did not have any such
problems yet. The 8.0.~3 instance will soon be migrated to 8.1.latest,
so I will skip the 8.0.5 step, even if it only means install/restart/no
dump - after all I had a single crash in a few months of operation.
I take it granted that the crash situation on table drop is fixed. I
wonder if temporary tables are still added to the autovacuum list in 8.1
or not ?
Thanks,
Csaba.
On Fri, 2006-01-20 at 17:07, Matthew T. O'Connor wrote:
> No I didn't mean to use the 8.1 autovac with 8.0, that can't work.
> Please upgrade your 8.0.x to at least 8.0.5 and see if that fixes the
> problem.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-20 16:29:55 | Re: Initdb panic: invalid record offset at 0/0 creating template1] |
| Previous Message | Richard Huxton | 2006-01-20 16:11:50 | Re: How to fetch rows with multiple values |