From: | bock(at)openit(dot)de |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6378: exceeding memory usage while creating index in pg-9.1.2 |
Date: | 2012-01-04 13:35:28 |
Message-ID: | E1RiR04-0001Wd-SS@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6378
Logged by: Julian v. Bock
Email address: bock(at)openit(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-01-04 14:48:57 | Re: BUG #6376: Cannot prepare a "CREATE TABLE" statement, error message is unhelpful |
Previous Message | moiseev.igor | 2012-01-04 11:15:40 | BUG #6377: some notice on the manual page |