Re: Implement UNLOGGED clause for COPY FROM - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Implement UNLOGGED clause for COPY FROM
Date
Msg-id CAA4eK1LJGB66WBPbPa=6ra0Tz=pp6ZjBeX6Go8C8mXLJp7DypA@mail.gmail.com
Whole thread Raw
In response to RE: Implement UNLOGGED clause for COPY FROM  ("osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>)
List pgsql-hackers
On Thu, Jul 9, 2020 at 11:47 AM osumi.takamichi@fujitsu.com
<osumi.takamichi@fujitsu.com> wrote:
>
>
> In terms of streaming replication,
> I'd like to ask for advice of other members in this community.
> Now, I think this feature requires to re-create standby
> immediately after the COPY UNLOGGED like Oracle's clause
>

This seems quite limiting to me and I think the same will be true for
subscribers that get data via logical replication, right?  I suspect
that the user will perform such an operation from time-to-time and
each time creating replica again could be really time-consuming and
maybe more than it will save by making this operation unlogged.

I wonder do they really need to replicate such a table and its data
because each time creating a replica from scratch after an operation
on one table doesn't sound advisable to me?

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Expand the use of check_canonical_path() for more GUCs
Next
From: Andy Fan
Date:
Subject: Re: Implementing Incremental View Maintenance