BUG #13447: Zombie postgres.exe processes

From: m8r-geob63(at)mailinator(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13447: Zombie postgres.exe processes
Date: 2015-06-17 00:06:50
Message-ID: 20150617000650.2732.3525@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13447
Logged by: Paul
Email address: m8r-geob63(at)mailinator(dot)com
PostgreSQL version: 9.4.1
Operating system: Win 7 x64
Description:

Postgres.exe instances are being "zombified" after large number of rows (few
million) are inserted. The instances will then stick around generally
holding onto 400-600 MB of RAM. These instances no longer show up in the
pgAdmin "Server Status" window. Closing all of the applications that were
using Posgres does not clear these from memory. The only way I can clear
these is to actually restart the Postgres service.

My application is using the libpq library for database operations and it
performs block transactions based on number of rows ready to be committed or
length of time since last commit. I can easily reproduce this problem so
it's not a one off occurrence.

Browse pgsql-bugs by date

  From Date Subject
Next Message Venkata Balaji N 2015-06-17 00:44:24 Re: pg_xlog on a hot_stanby slave
Previous Message Jose Alberto Lopez 2015-06-16 23:28:25 Statics collector