Обсуждение: BUG #8573: int4range memory consumption

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.