[GENERAL] slow query on multiple table join

hi guys， I met a query performance issue in postgresql 9.6.2 with multiple tables joined. there were 2 slow queries,and the reasons were the same:the optimizer generate a bad explain which using nest loop. attached is the query and its explain.all tables are small and the indexes were only c

[GENERAL] checkpoint and recovering process use too much memory

hi dears, I had an asynchronous steaming replication HA cluster.Each node had 64G memory.pg is 9.6.2 and deployed on centos 6. Last month the database was killed by OS kernel for OOM,the checkpoint process was killed. I noticed checkpoint process occupied memory for more than 20GB，and it wa

Re: [GENERAL] checkpoint and recovering process use too much memory

Pryzby wrote: > On Fri, Nov 03, 2017 at 01:43:32AM +0000, tao tony wrote: >> I had an asynchronous steaming replication HA cluster.Each node had 64G >> memory.pg is 9.6.2 and deployed on centos 6. >> >> Last month the database was killed by OS kernel for OOM,the checkpoint