Re: synchronous_commit=off doesn't always return immediately

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tomrevam <tomer(at)fabrix(dot)tv>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: synchronous_commit=off doesn't always return immediately
Date: 2009-07-23 14:44:58
Message-ID: 16291.1248360298@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tomrevam <tomer(at)fabrix(dot)tv> writes:
> I set synchronous_commit to off and expected trivial inserts (single row,
> 6-8 columns) to always return quickly. However, I see that during
> checkpoints they sometimes take over a second.

What sort of disk hardware have you got? It sounds overstressed.

It might help to increase wal_buffers.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Seaborn 2009-07-23 14:47:44 Search Path vs Synonyms
Previous Message Pavel Stehule 2009-07-23 14:36:55 Re: comparing NEW and OLD (any good this way?)