Re: Huge backend memory footprint

2017-12-25 Thread Konstantin Knizhnik
On 22.12.2017 16:21, Andres Freund wrote: Hi, On 2017-12-22 16:07:23 +0300, Konstantin Knizhnik wrote: While my experiments with pthreads version of Postgres I find out that I can not create more than 100k backends even at the system with 4Tb of RAM. I don't think this is a problem we need t

Re: Huge backend memory footprint

2017-12-22 Thread Konstantin Knizhnik
On 22.12.2017 16:13, Claudio Freire wrote: On Fri, Dec 22, 2017 at 10:07 AM, Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> wrote: While my experiments with pthreads version of Postgres I find out that I can not create more than 100k backends even at the system with 4Tb

Re: Huge backend memory footprint

2017-12-22 Thread Andres Freund
Hi, On 2017-12-22 16:07:23 +0300, Konstantin Knizhnik wrote: > While my experiments with pthreads version of Postgres I find out that I can > not create more than 100k backends even at the system with 4Tb of RAM. I don't think this is a problem we need to address at this point. Would you care to

Re: Huge backend memory footprint

2017-12-22 Thread Claudio Freire
On Fri, Dec 22, 2017 at 10:07 AM, Konstantin Knizhnik < k.knizh...@postgrespro.ru> wrote: > While my experiments with pthreads version of Postgres I find out that I > can not create more than 100k backends even at the system with 4Tb of RAM. > I do not want to discuss now the idea of creating so l

Huge backend memory footprint

2017-12-22 Thread Konstantin Knizhnik
While my experiments with pthreads version of Postgres I find out that I can not create more than 100k backends even at the system with 4Tb of RAM. I do not want to discuss now the idea of creating so large number of backends - yes, most of the real production systems are using pgbouncer or simi