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

Bug #686: growing tables

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #686: growing tables
Date: 2002-06-07 16:20:11
Message-ID: 20020607162011.28554476092@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Dmitry Kishchukov (dek(at)mit8(dot)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


Responses

pgsql-bugs by date

Next:From: Neil ConwayDate: 2002-06-07 18:56:01
Subject: Re: Bug #686: growing tables
Previous:From: pgsql-bugsDate: 2002-06-07 10:30:50
Subject: Bug #685: pg_dump don't works with many tables

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