Re: Postgresql 9.1.2 - abnormal memory usage

Hi,

On Sunday, December 11, 2011 10:15:29 PM Jochen Erwied wrote:
> The following script can be used to show the behaviour:
>
> create database pgtest;
> \c pgtest
> create table test(var inet);
> insert into test(var) '127.0.0.0'::inet+generate_series(0,256*256*256-1);
> create index test_ix on test(var);
I can reproduce the issue. The memory is being spent at only one place:

TopMemoryContext: 68688 total in 10 blocks; 2736 free (10 chunks); 65952 used
  TopTransactionContext: 8192 total in 1 blocks; 4856 free (0 chunks); 3336
used
  PortalMemory: 8192 total in 1 blocks; 7888 free (0 chunks); 304 used
    PortalHeapMemory: 15360 total in 4 blocks; 10640 free (17 chunks); 4720
used
      TupleSort: 6283429096 total in 723 blocks; 1424704 free (0 chunks);
6282004392 used

Looking.

Andres