memory leak while using vaccum
От | Achim Krümmel |
---|---|
Тема | memory leak while using vaccum |
Дата | |
Msg-id | 3B835F3F.E597014C@dohle.com обсуждение исходный текст |
Ответы |
Re: memory leak while using vaccum
|
Список | pgsql-bugs |
I am running a PostgreSQL 7.1.3 on a Intel Pentium III My operating system is SuSE Linux 7.1 with Kernel 2.4.4 (ELF) I compiled postgresql with gcc 2.95.2 My problem: when using "vacuum analyze <tablename>" on very large tables (I have one with about 30GB) the memory usage increases continues until no memory is left and the kernel stops this process. I suppose this problem is easy to reproduce. Just create a table like this: Table "wa_cube"Attribute | Type | Modifier -----------+---------------+----------dim1 | numeric(38,0) |dim2 | numeric(38,0) |dim3 | numeric(38,0) |dim4 | numeric(38,0) |dim5 | numeric(38,0) |lvkumsatz | numeric(14,3) |vkumsatz | numeric(14,3) |ekumsatz | numeric(14,3)|menge | numeric(14,3) | Index: wa_cube_idx fill very much data into it, then create an index like this: Index "wa_cube_idx"Attribute | Type -----------+---------------dim1 | numeric(38,0)dim2 | numeric(38,0)dim3 | numeric(38,0)dim4 | numeric(38,0) btree and run: vacuum anayze <table> greetings, Achim Kruemmel
В списке pgsql-bugs по дате отправления: