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

From Steve Singer
Subject Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)
Date
Msg-id alpine.DEB.2.11.1811012241440.3854@opti.atlantida
Whole thread Raw
In response to Re: heap_sync seems rather oblivious to partitioned tables (wal_level=minimal)  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: heap_sync seems rather oblivious to partitioned tables (wal_level=minimal)
List pgsql-hackers
On Thu, 1 Nov 2018, David Rowley wrote:

>
> I ended up going with:
>
>    However, this consideration only applies when
>    <xref linkend="guc-wal-level"/> is <literal>minimal</literal> for
>    non-partitioned tables as all commands must write WAL otherwise.
>

>
> I've changed this to:
>
>      Rows will be frozen only if the table being loaded has been created
>      or truncated in the current subtransaction, there are no cursors
>      open and there are no older snapshots held by this transaction.  It is
>      currently not possible to perform a <command>COPY FREEZE</command> on
>      a partitioned table.
>
> Which is just the original text with the new sentence tagged onto the end.
>
>> Other than that the patch looks fine and works as expected.
>>
>> The new status of this patch is: Waiting on Author
>
> Thanks for looking at this. I've attached an updated patch.

I am happy with the changes.
I think the patch is ready for a committer.


>
> -- 
> David Rowley                   http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

Steve



pgsql-hackers by date:

Previous
From: Euler Taveira
Date:
Subject: Re: row filtering for logical replication
Next
From: Amit Langote
Date:
Subject: Re: partitioned indexes and tablespaces