Re: COPY FROM - to avoid WAL generation

From: Ravi Krishna <sravikrishna(at)aol(dot)com>
To:
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: COPY FROM - to avoid WAL generation
Date: 2018-08-21 15:42:48
Message-ID: 694920939.390114.1534866168667@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>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.
 

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2018-08-21 16:14:14 Re: Multiple COPY on the same table
Previous Message Andres Freund 2018-08-21 15:31:28 Re: COPY FROM - to avoid WAL generation