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

From Бородин Владимир
Subject Re: Problem with ExclusiveLock on inserts
Date
Msg-id E51EDB5C-E86C-4C72-B1FA-EB486EA0CF4A@simply.name
Whole thread Raw
In response to Re: Problem with ExclusiveLock on inserts  (Emre Hasegeli <emre@hasegeli.com>)
Responses Re: Problem with ExclusiveLock on inserts
List pgsql-performance
Cool. How much ram do you have on your server and what is the size of the database?

My settings of 32 GB was set due to recommendation of 25% from here [1]. Right now I am going to investigate the content of buffer cache with pg_buffercache and maybe OS page cache with recently released pg_stat_kcache to determine the optimal size for my load profile.

[1] http://www.postgresql.org/docs/current/static/runtime-config-resource.html

13.02.2014, в 13:13, Emre Hasegeli <emre@hasegeli.com> написал(а):

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: Emre Hasegeli
Date:
Subject: Re: Problem with ExclusiveLock on inserts
Next
From: Ilya Kosmodemiansky
Date:
Subject: Re: Problem with ExclusiveLock on inserts