The following bug has been logged on the website:
Bug reference: 8573
Logged by: Godfried Vanluffelen
Email address: g.vanluffelen@qipc.com
PostgreSQL version: 9.3.1
Operating system: Windows 7 64 bit
Description:
int4range ( and any other range function) consumes much memory when used in
a select statement on a big table.
steps to reproduce:
-generate or use a table with 10M+ rows with 2 columns that are usable to
create a range. For example 1 column with negative numbers, and one with
positive numbers.
-invoke a simple select statement where you create a range of 2 columns. For
example select int4range(col1,col2) from table.
-memory builds up until the query is finished, or when out of memory error
occurs.