Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)

Поиск
Список
Период
Сортировка
От Steve Singer
Тема Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)
Дата
Msg-id alpine.DEB.2.11.1811012241440.3854@opti.atlantida
обсуждение исходный текст
Ответ на Re: heap_sync seems rather oblivious to partitioned tables (wal_level=minimal)  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: heap_sync seems rather oblivious to partitioned tables (wal_level=minimal)  (David Rowley <david.rowley@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Euler Taveira
Дата:
Сообщение: Re: row filtering for logical replication
Следующее
От: Amit Langote
Дата:
Сообщение: Re: partitioned indexes and tablespaces