Re: Blocking every 20 sec while mass copying.

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Benjamin Dugast <bdugast(at)excilys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Blocking every 20 sec while mass copying.
Date: 2014-07-18 15:16:54
Message-ID: m3tx6eg0ih.fsf@mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2014-07-18 17:56:35 Re: Blocking every 20 sec while mass copying.
Previous Message Albe Laurenz 2014-07-18 11:11:34 Re: Blocking every 20 sec while mass copying.