From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: Memory leak in backend on failed inserts |
Date: | 1999-01-14 19:10:27 |
Message-ID: | 199901141910.OAA07555@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Thomas Reinke
Your email address : reinke(at)e-softinc(dot)com
Category : runtime: back-end
Severity : serious
Summary: Memory leak in backend on failed inserts
System Configuration
--------------------
Operating System : Linux 2.0.30 RedHat
PostgreSQL version : 6.3
Compiler used : gcc 2.7.2.1
Hardware:
---------
Linux www4 2.0.30 #1 Tue Apr 22 10:49:45 EDT 1997 i686 unknown
Pentium MMX 128 Meg
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
The postgres backend leaks memory in a serious fashion
on failed inserts. With batch programs doing many inserts,
a system with 212 Meg virtual memory runs out of memory
after approximately 20,000 failed inserts.
Workaround: repeatedly reset the database connection
to close the old backend down and start a new one.
--------------------------------------------------------------------------
Test Case:
----------
Any failed insert, repeatedly done, will demonstrate
this leak.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1999-01-18 14:03:53 | General Bug Report: Buffer query in MainLoop of psql is never flushed |
Previous Message | Javier Kohen | 1999-01-14 09:32:18 | create view foo as select avg(x), avg(y) from bar; "ERROR: attribute 'avg' duplicated" BUG or FEATURE? |