Re: Problem with ExclusiveLock on inserts - Mailing list pgsql-performance

From Emre Hasegeli
Subject Re: Problem with ExclusiveLock on inserts
Date
Msg-id CAE2gYzwDoJELzbs9Wc44SPOjO4U9QWNr+RT5c6pFSHm9nfbi4w@mail.gmail.com
Whole thread Raw
In response to Problem with ExclusiveLock on inserts  (Бородин Владимир <root@simply.name>)
Responses Re: Problem with ExclusiveLock on inserts  (Бородин Владимир <root@simply.name>)
List pgsql-performance
2014-02-12 18:59, Бородин Владимир <root@simply.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.


pgsql-performance by date:

Previous
From: Бородин Владимир
Date:
Subject: Re: Problem with ExclusiveLock on inserts
Next
From: Бородин Владимир
Date:
Subject: Re: Problem with ExclusiveLock on inserts