Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Implement UNLOGGED clause for COPY FROM
Date
Msg-id CAKFQuwbqDGVt6opR8sX=+RmBHpdkE4D2Z-HJH1brgEyq57RqLA@mail.gmail.com
Whole thread Raw
In response to Implement UNLOGGED clause for COPY FROM  ("osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>)
Responses RE: Implement UNLOGGED clause for COPY FROM  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
RE: Implement UNLOGGED clause for COPY FROM  ("osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>)
List pgsql-hackers
Tree view
On Wednesday, July 8, 2020, osumi.takamichi@fujitsu.com <osumi.takamichi@fujitsu.com> wrote:
5. Sync the data to disk by performing checkpoint.

This step seems to invalidate the idea outright.  The checkpoint command is superuser only and isn’t table specific.  This seems to require both those things to be changed.

Aside from that, though, how does this improve upon the existing capability to copy into an unlogged temporary table?

David J.

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pgsql-hackers archive broken?
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_resetwal --next-transaction-id may cause database failed to restart.