Postgres Pro
Downloads
Home   >   mailing lists

Re: GSoC proposal - "make an unlogged table logged" - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: GSoC proposal - "make an unlogged table logged"
Date
Msg-id 533AFDB4.8050209@nasby.net
Whole thread Raw
In response to Re: GSoC proposal - "make an unlogged table logged"  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: GSoC proposal - "make an unlogged table logged"  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On 3/4/14, 8:50 AM, Andres Freund wrote:
> Can't that be solved by just creating the permanent relation in a new
> relfilenode? That's equivalent to a rewrite, yes, but we need to do that
> for anything but wal_level=minimal anyway.

Maybe I'm missing something, but doesn't this actually involve writing the data twice? Once into WAL and again into the
relationitself?
 
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
Next
From: Robert Haas
Date:
Subject: Re: Inheritance of foregn key constraints.