| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | "g(dot)bakalarski(at)icm(dot)edu(dot)pl" <g(dot)bakalarski(at)icm(dot)edu(dot)pl>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #8318: memory leak during CREATE TEMPORARY TABLE |
| Date: | 2013-07-30 21:38:00 |
| Message-ID: | 1375220280.46993.YahooMailNeo@web162905.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"g(dot)bakalarski(at)icm(dot)edu(dot)pl" <g(dot)bakalarski(at)icm(dot)edu(dot)pl> wrote:
> When doing these kind of statements
> execute <unnamed>: CREATE TEMPORARY TABLE [...]
> After few days [...] my huge server (192GB of RAM), gets stucked
> due to no memory available (usually %commit is around 103-105%),
> linux OOM killer goes into action - it usually kills one of
> postgres processes - postmaster restart all databases) and after
> all linux has again some 100GB of not commited memory
What do you have as settings for temp_buffers and max_connections?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | devadas_mallya | 2013-07-30 21:58:55 | BUG #8346: Postgres BDR: Segmentation Fault observed during replication of binary object. |
| Previous Message | Michael Paquier | 2013-07-30 21:25:21 | Re: BUG #8345: PostGre SQL database is crashing |