Postgres Pro
Downloads
Home   >   mailing lists

Re: Bulk Insert into PostgreSQL - Mailing list pgsql-hackers

From Ashwin Agrawal
Subject Re: Bulk Insert into PostgreSQL
Date
Msg-id CALfoeit3Uxzi=3=oqkcohVGSFbu6M5zr+w1jw=csR792kEhWog@mail.gmail.com
Whole thread Raw
In response to Re: Bulk Insert into PostgreSQL  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view

On Sat, Jun 30, 2018 at 6:27 AM Craig Ringer <craig@2ndquadrant.com> wrote:

You can also gain a bit by running with wal_level = minimal. On newer version you can use UNLOGGED tables then convert them to logged, but that won't be an option for 9.4.

Curious to know more on this does with standby also its faster or only without standby this option can be faster ?

pgsql-hackers by date:

Previous
From: "Tsunakawa, Takayuki"
Date:
Subject: How can we submit code patches that implement our (pending) patents?
Next
From: Craig Ringer
Date:
Subject: Re: How can we submit code patches that implement our (pending) patents?