Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)
Date
Msg-id 20181119141907.jfoa76ikca7hzg56@alvherre.pgsql
Whole thread Raw
In response to Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: heap_sync seems rather oblivious to partitioned tables (wal_level=minimal)
List pgsql-hackers
On 2018-Nov-19, Tomas Vondra wrote:

> On 11/17/18 4:53 PM, Alvaro Herrera wrote:
> > Here are versions for branches 10 and 11.  The main change is that the
> > COPY test didn't have the partitioned table, because it was recently
> > introduced (0d5f05cde011) so I backpatched that part also.  It's a bit
> > useless, but I'd rather backpatch the same thing rather than have
> > different lines there ...
> 
> The patch seems fine to me.

Pushed now, thanks.

> It's a bit unfortunate that we simply disable the optimization on
> partitioned tables instead of fixing it somehow, but I guess it's better
> than nothing and no one has a very good idea how to make it work.

Yeah, I think leaving it in the current state is worse than disabling
it, since an error is thrown anyway.  In any case, I guess when we have
a patch it won't be backpatchable.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: New GUC to sample log queries
Next
From: Adelino Silva
Date:
Subject: