Bug #686: growing tables - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #686: growing tables
Date
Msg-id 20020607162011.28554476092@postgresql.org
Whole thread Raw
Responses Re: Bug #686: growing tables  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-bugs
Dmitry Kishchukov (dek@mit8.ru) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
growing tables

Long Description
When I executing updates on small table (250 rows)
it tables grows. In my database one table contains only 250 rows
(two number, ip and date) take 170MB disk space!

If I drop and create table (with export and import data) - all right
but leter it begin growing

command 'valuum' dont help.

What is this?

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #685: pg_dump don't works with many tables
Next
From: Neil Conway
Date:
Subject: Re: Bug #686: growing tables