| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0 |
| Date: | 2007-01-12 16:22:59 |
| Message-ID: | 20070112162259.GE27743@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Maybe we could forcibly activate the freeze mode on a template database?
>
> Might not be a bad idea. And even more to the point, forcibly disable
> analyze.
Patch implementing this (albeit untested!) attached. I'll try to
reproduce the problem without the patch, and then test with the patch
applied.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| Attachment | Content-Type | Size |
|---|---|---|
| autovac-freeze.patch | text/x-diff | 5.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-01-12 16:35:25 | Re: [HACKERS] Checkpoint request failed on version 8.2.1. |
| Previous Message | Al Balmer | 2007-01-12 16:20:21 | Version 8.2 for HP-UX |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-01-12 16:35:25 | Re: [HACKERS] Checkpoint request failed on version 8.2.1. |
| Previous Message | Magnus Hagander | 2007-01-12 16:06:09 | Re: [HACKERS] Checkpoint request failed on version 8.2.1. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-01-12 16:44:39 | Re: [HACKERS] [PATCHES] Patch to log usage of |
| Previous Message | Peter Eisentraut | 2007-01-12 16:19:40 | Re: Allow dumping of roles or tablespaces |