BUG #13447: Zombie postgres.exe processes - Mailing list pgsql-bugs

From m8r-geob63@mailinator.com
Subject BUG #13447: Zombie postgres.exe processes
Date
Msg-id 20150617000650.2732.3525@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13447
Logged by:          Paul
Email address:      m8r-geob63@mailinator.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.

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #13448: DOC about : pg_dump use logical replication snapshot
Next
From: Curd Reinert
Date:
Subject: Re: BUG #13440: unaccent does not remove all diacritics