Re: Problem with ExclusiveLock on inserts

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: Бородин Владимир <root(at)simply(dot)name>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with ExclusiveLock on inserts
Date: 2014-02-13 09:13:23
Message-ID: CAE2gYzwDoJELzbs9Wc44SPOjO4U9QWNr+RT5c6pFSHm9nfbi4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2014-02-12 18:59, Бородин Владимир <root(at)simply(dot)name>:
> I have read several topics [1, 2, 3, 4] with similar problems but haven't
> find a good solution. Below is some more diagnostics.

I reported the second one. The diagnostics was very similar to yours.
I think a lot people experienced this problem with big servers. It was
only because of large shared_buffers. The problem disappeared after
we reduced it to 2 GB.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Бородин Владимир 2014-02-13 09:23:06 Re: Problem with ExclusiveLock on inserts
Previous Message Бородин Владимир 2014-02-13 08:35:36 Re: Problem with ExclusiveLock on inserts