Re: GSoC proposal - "make an unlogged table logged"

On Mon, Mar 3, 2014 at 5:47 PM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:
>
> On 2014-03-03 12:44:26 -0800, Peter Geoghegan wrote:
> > On Mon, Mar 3, 2014 at 8:28 AM, Fabrízio de Royes Mello
> > <fabriziomello(at)gmail(dot)com> wrote:
> > > Is the TODO item "make an unlogged table logged" [1] a good GSoC
project?
> >
> > Another interesting project around unlogged tables would be to make it
> > possible to have unlogged indexes on fully-logged tables. That is
> > something that there was some discussion of before, that might be
> > easier.
>
> I'd actually say it's harder because it requires modifying the catalog
> or transparently introducing hacks similar to what unlogged matviews are
> doing, to make sure the index is marked invalid after a crash restart.
>

Unlogged matviews was disallowed [1].

[1]
http://www.postgresql.org/message-id/E1UZNrD-0008Eh-83@gemulon.postgresql.org

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello