memory leak while using vaccum - Mailing list pgsql-bugs

From Achim Krümmel
Subject memory leak while using vaccum
Date
Msg-id 3B835F3F.E597014C@dohle.com
Whole thread Raw
Responses Re: memory leak while using vaccum  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: memory leak while using vaccum
Next
From: Andreas Wernitznig
Date:
Subject: Re: Re: low performance