BUG #8013: Memory leak

From: stiening(at)comcast(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8013: Memory leak
Date: 2013-03-30 14:01:27
Message-ID: E1ULwLX-0007BV-Mz@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: 8013
Logged by: Rae Stiening
Email address: stiening(at)comcast(dot)net
PostgreSQL version: 9.2.3
Operating system: Suse Linux 9.3
Description:

The query:
SELECT pts_key,count(*)
FROM tm_tm_pairs GROUP BY pts_key HAVING count(*) !=1 ORDER BY
pts_key

Which is executed as:
GroupAggregate (cost=108680937.80..119278286.60 rows=470993280 width=4)
Filter: (count(*) <> 1)
-> Sort (cost=108680937.80..109858421.00 rows=470993280 width=4)
Sort Key: pts_key
-> Seq Scan on tm_tm_pairs (cost=0.00..8634876.80 rows=470993280
width=4)

uses all available memory (32GB). pts_key is an integer and the table
contains about 500 million rows.

PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux)
4.7.2 20130108 [gcc-4_7-branch revision 195012], 64-bit
(

compile options:

env CFLAGS='-O3 -march=native' ./configure --with-segsize=128

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2013-03-30 17:21:44 Re: Completely broken replica after PANIC: WAL contains references to invalid pages
Previous Message Sergey Konoplev 2013-03-29 21:53:26 Re: Completely broken replica after PANIC: WAL contains references to invalid pages