"g.bakalarski@icm.edu.pl" <g.bakalarski@icm.edu.pl> wrote:=0A=0A> When doin=
g these kind of statements=0A=0A> execute <unnamed>: CREATE TEMPORARY TABLE=
[...]=0A=0A> After few days [...] my huge server (192GB of RAM), gets stuc=
ked=0A> due to no memory available (usually %commit is around 103-105%),=0A=
> linux OOM killer goes into action - it usually kills one of=0A> postgres =
processes - postmaster restart all databases) and after=0A> all linux=A0 ha=
s again some 100GB of not commited memory=0A=0AWhat do you have as settings=
for temp_buffers and max_connections?=0A=0A--=0AKevin Grittner=0AEDB: http=
://www.enterprisedb.com=0AThe Enterprise PostgreSQL Company