Postgres Pro
Downloads
Home   >   mailing lists

memory leak in e94568ecc10 (pre-reading in external sort) - Mailing list pgsql-hackers

From Tomas Vondra
Subject memory leak in e94568ecc10 (pre-reading in external sort)
Date
Msg-id 7303da46-daf7-9c68-3cc1-9f83235cf37e@2ndquadrant.com
Whole thread Raw
Responses Re: memory leak in e94568ecc10 (pre-reading in external sort)  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Transactions involving multiple postgres foreign servers
Next
From: Pavan Deolasee
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)