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
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 |