Re: unlogged tables vs. GIST - Mailing list pgsql-hackers

From Robert Haas
Subject Re: unlogged tables vs. GIST
Date
Msg-id CA+Tgmobya4Lvja+UyFo7-wxW2tyy6N0_=9_TSxaS0iyjp78Scw@mail.gmail.com
Whole thread Raw
In response to Re: unlogged tables vs. GIST  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On Mon, Jan 28, 2013 at 4:04 AM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> Do we need to do anything to unloggedLSN in pg_resetxlog?

Does the server go into recovery after pg_resetxlog?  If so, no.  If
not, probably, but I have no idea what.  There's no "safe" value in
that case; what we ought to do is force a reset of all unlogged
relations, or just punt and hope nothing bad happens (which after all
is what pg_resetxlog is mostly about anyway).

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: allowing privileges on untrusted languages
Next
From: Robert Haas
Date:
Subject: Re: Patches for TODO item: Avoid truncating empty OCDR temp tables on COMMIT