BUG #6378: exceeding memory usage while creating index in pg-9.1.2

Started by Nonameover 14 years ago3 messagesbugs
Jump to latest
#1Noname
bock@openit.de

The following bug has been logged on the website:

Bug reference: 6378
Logged by: Julian v. Bock
Email address: bock@openit.de
PostgreSQL version: 9.1.2
Operating system: Linux x86_64
Description:

When creating an index on an inet column the postmaster process tries to
allocate much more memory than it should in version 9.1.2.

In my test db (maintenance_work_mem = 1gb; shared_buffers = 256mb) the
CREATE INDEX in the script below runs out of memory after allocating several
GB. Note that this does not happen with version 9.1.1 (only a few hundred MB
are allocated).

-----------
create table iptest ( id serial primary key, ip inet );

insert into iptest ( ip )
( select ( '192.' || a || '.' || b || '.' || c )::inet
from generate_series( 0, 127 ) a,
generate_series( 0, 255 ) b,
generate_series( 0, 255 ) c );

create index iptest_idx_1 on iptest ( ip );
-----------

Regards,
Julian v. Bock

#2Andres Freund
andres@anarazel.de
In reply to: Noname (#1)
Re: BUG #6378: exceeding memory usage while creating index in pg-9.1.2

This has been fixed since 9.1.2. If you browse the history and/or this mailing list you should find a reference.

I just have my mobile here, so its a bit too hard to search for a reference....

Greetings,

Andres

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #6378: exceeding memory usage while creating index in pg-9.1.2

bock@openit.de writes:

When creating an index on an inet column the postmaster process tries to
allocate much more memory than it should in version 9.1.2.

Yeah, a memory leak was accidentally introduced into inet/cidr index
operations in 9.1.2. It will be fixed in 9.1.3, or if you're in a hurry
the patch is here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6cf639dfbddbc44d027730ad1504886312bc905a

regards, tom lane