Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group