| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Autovacuum vs statement_timeout |
| Date: | 2007-04-18 15:00:09 |
| Message-ID: | 20070418150009.GC7356@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Treat wrote:
> On Tuesday 17 April 2007 21:25, Alvaro Herrera wrote:
> > I think that is too strong an assumption, which is why I'm planning to
> > back-patch the change to reset statement_timeout to 0 on autovacuum till
> > 8.0, as discussed. I think I should also backpatch the change to set
> > zero_damaged_pages as well (which is not on 8.0 AFAIR).
>
> <blinks> Um, can I get a pointer to that thread? I can't imagine why we
> would actually want to automatically destroy our data without oversight from
> a DBA... I must be reading that wrong.
You are -- I intend to set it to _off_ :-)
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harvell F | 2007-04-18 15:15:06 | Re: Backend Crash |
| Previous Message | Robert Treat | 2007-04-18 14:58:45 | Re: Autovacuum vs statement_timeout |