Re: postgresql 9.1 out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Евгений Селявка <evg(dot)selyavka(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgresql 9.1 out of memory
Date: 2013-10-26 13:59:27
Message-ID: 11526.1382795967@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?KOI8-R?B?5dfHxc7JyiDzxczR18vB?= <evg(dot)selyavka(at)gmail(dot)com> writes:
> today my database crashed with out of memory

This is probably why:

> work_mem = 2GB

Don't do that. It's especially silly to have this setting higher than
maintenance_work_mem --- should be the other way 'round.

I would also question your setting of shared_buffers. The traditional
advice is to dedicate maybe a quarter of RAM to shared_buffers, not
three-quarters.

For more info try

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David Johnston 2013-10-26 19:18:46 Re: postgresql 9.1 out of memory
Previous Message Евгений Селявка 2013-10-26 12:54:27 postgresql 9.1 out of memory