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@xxxxxxxxxxxx> написал(а): 2014-02-12 18:59, Бородин Владимир <root@xxxxxxxxxxx>:I have read several topics [1, 2, 3, 4] with similar problems but haven't |