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

Поиск
Список
Период
Сортировка
От bock@openit.de
Тема BUG #6378: exceeding memory usage while creating index in pg-9.1.2
Дата
Msg-id E1RiR04-0001Wd-SS@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6378: exceeding memory usage while creating index in pg-9.1.2  ("anarazel@anarazel.de" <andres@anarazel.de>)
Re: BUG #6378: exceeding memory usage while creating index in pg-9.1.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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:=20=20=20=20=20=20=20=20

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 =3D 1gb; shared_buffers =3D 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: moiseev.igor@gmail.com
Дата:
Сообщение: BUG #6377: some notice on the manual page
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #6376: Cannot prepare a "CREATE TABLE" statement, error message is unhelpful