Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version

On Fri, Apr 10, 2020 at 1:16 AM Justin Pryzby wrote: > On Fri, Apr 10, 2020 at 12:51:03AM +1000, Maxim Boguk wrote: > > With database on dedicated server I encountered unusual load profile: > > multi thread (200 connections static size pool via pgbouncer) insert only > > into single table around

Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version

On Fri, Apr 10, 2020 at 12:51:03AM +1000, Maxim Boguk wrote: > With database on dedicated server I encountered unusual load profile: > multi thread (200 connections static size pool via pgbouncer) insert only > into single table around 15.000 insert/s. > > Usually insert took 0.025ms and amount ac

High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version

Hi, I have performance issues which I never seen before in my 20+ years experience with PostgreSQL. With database on dedicated server I encountered unusual load profile: multi thread (200 connections static size pool via pgbouncer) insert only into single table around 15.000 insert/s. Usually in