From: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
---|---|
To: | Бородин Владимир <root(at)simply(dot)name> |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Problem with ExclusiveLock on inserts |
Date: | 2014-02-13 10:00:16 |
Message-ID: | CAE2gYzxk9M1n+AE29oiiJmNZWRY1JsHf_ykc2+5Kbu+fMgB=Ew@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Thu, Feb 13, 2014 at 11:23 AM, Бородин Владимир <root(at)simply(dot)name> wrote:
> Cool. How much ram do you have on your server and what is the size of the
> database?
It has 200 GiB of memory for 100 GB database at that time. We had migrated
the database from MySQL, that was the reason of overmuch resources. I do
not maintain it anymore and I moved the database to much smaller server
before I leave.
> My settings of 32 GB was set due to recommendation of 25% from here [1].
Maybe we should add a note to that page.
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Бородин Владимир | 2014-02-13 10:26:49 | Re: Problem with ExclusiveLock on inserts |
Previous Message | Ilya Kosmodemiansky | 2014-02-13 09:29:11 | Re: Problem with ExclusiveLock on inserts |