RE: PostgreSQL memory usage

авлено: 17 октября 2019 г. 14:09 Кому: Alexander Pyhalov; pgsql-general@lists.postgresql.org Тема: Re: PostgreSQL memory usage Alexander Pyhalov wrote: > After looking at my DBMS server for some time I've understood that I don't > understand what was going on... > > A server

PostgreSQL memory usage

Hello. After looking at my DBMS server for some time I've understood that I don't understand what was going on... A server has 48 GB RAM. shared_buffers is set to 12GB, work_mem - to 32MB, pgbouncer in transaction mode is used to connect pool (pool size 80) to PostgreSQL 10.5 server. I see t

LWLock optimization

Hi. I was asked to bring up this topic on maling lists after asking question on IRC. The issue is the following. On one of our servers (10.5), I see a lot of queries with wait_event_type='LWLock', wait_event='lock_manager' This is a stat gathering/analyzing application with tables which have

Re: duplicate primary key

It's PostgreSQL 9.5.10 (64bit), running on Ubuntu 16.04. Last major update was done as full dump/restore. -- Best regards, Alexander Pyhalov, system administrator of Southern Federal University IT department

duplicate primary key

14875 | 3149449600 | 3152681810 18319 | (9976870,49) | 14875 | 3149448769 | 3152328995 I don't understand how this could have happened -- Best regards, Alexander Pyhalov, 3152328995 system administrator of Southern Federal University IT department