Re: Blocking every 20 sec while mass copying. - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: Blocking every 20 sec while mass copying.
Date
Msg-id m3tx6eg0ih.fsf@mnc.ch
Whole thread Raw
In response to Blocking every 20 sec while mass copying.  (Benjamin Dugast <bdugast@excilys.com>)
List pgsql-performance
Benjamin Dugast <bdugast 'at' excilys.com> writes:

>   • fsync to off (that helped but we can't do this)

not exactly your question, but maybe synchronous_commit=off is a
nice enough intermediary solution for you (it may give better
performances at other places too for only an affordable cost)

--
Guillaume Cottenceau


pgsql-performance by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Blocking every 20 sec while mass copying.
Next
From: Jeff Janes
Date:
Subject: Re: Blocking every 20 sec while mass copying.