Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY FROM - to avoid WAL generation - Mailing list pgsql-general

From Ravi Krishna
Subject Re: COPY FROM - to avoid WAL generation
Date
Msg-id 694920939.390114.1534866168667@mail.yahoo.com
Whole thread Raw
In response to COPY FROM - to avoid WAL generation  (Ravi Krishna <sravikrishna@aol.com>)
List pgsql-general
Tree view

>Please note this is only the case if wal_level = minimal. If replication
>(or PITR) is supported, that mode can't be used, because the data has to
>go into the WAL.
>Were you using wal_level = minimal?

Aha. No it was not minimal.
 
For a second I thought PG is super smart. Oh well.
 
Thanks.
 

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: COPY FROM - to avoid WAL generation
Next
From: Christopher Browne
Date:
Subject: Re: Multiple COPY on the same table