memory leak in e94568ecc10 (pre-reading in external sort)

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: memory leak in e94568ecc10 (pre-reading in external sort)
Date: 2016-10-06 04:50:41
Message-ID: 7303da46-daf7-9c68-3cc1-9f83235cf37e@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

it seems e94568ecc10 has a pretty bad memory leak. A simple

pgbench -i -s 300

allocates ~32GB of memory before it fails

vacuum...
set primary keys...
ERROR: out of memory
DETAIL: Failed on request of size 134184960.

The relevant bit from the memory context stats:

TupleSort main: 33278738504 total in 263 blocks; 78848 free (23 chunks);
33278659656 used

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2016-10-06 05:36:14 Re: Patch: Write Amplification Reduction Method (WARM)
Previous Message Ashutosh Bapat 2016-10-06 04:41:04 Re: Transactions involving multiple postgres foreign servers