Re: BUG #2667: vacuuming a 70GB table causes a "crash"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2667: vacuuming a 70GB table causes a "crash"
Date: 2006-10-02 02:05:43
Message-ID: 26347.1159754743@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Stephen R. van den Berg" <srb(at)cuci(dot)nl> writes:
> On 9/30/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Were you running with full_page_writes off during some earlier use of
>> this database?

> My postgres.conf file says:
> full_page_writes = off
> As I understand it, the 8.1.4 postgres ignores this setting?

Indeed. But I'm speculating that the damage was done by an earlier
8.1.x release and you've only just now discovered it.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chris Dunlop 2006-10-02 02:19:50 Update using sub-select table in schema
Previous Message Tom Lane 2006-10-02 02:04:06 Re: BUG #2669: The config dir was empty -> cannot find install-sh or install.sh in config ./config