On Mon, Mar 3, 2014 at 5:47 PM, Andres Freund <and...@2ndquadrant.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 > > <fabriziome...@gmail.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...@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