The following bug has been logged on the website:
Bug reference: 8013
Logged by: Rae Stiening
Email address: stien...@comcast.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
