memory leak while using vaccum

From: Achim Krümmel <akruemmel(at)dohle(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: memory leak while using vaccum
Date: 2001-08-22 07:29:03
Message-ID: 3B835F3F.E597014C@dohle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Wernitznig 2001-08-22 21:35:20 Re: Re: low performance
Previous Message Tom Lane 2001-08-22 07:08:05 Re: memory leak while using vaccum