Re: table growing

On Mon, 4 Nov 2002, Stephane Tessier wrote:

> Hi
>
> I have a growing database problem. I insert rows in a table
> automatically(1500 by hour approx) and I use this table like a temporary
> table 24/7.All rows inserted are
> deleted(maybe 12-24 hours later)but the database grow all the time I
> tried vacuum,analyze,vacuum full, reindex, max_fsm_pages =100000,1000000
> etc.
>
> the only way to reduce space is dump table /drop table/create table and
> insert after but after 12-24 hours. the table is very big and request
> are very slow
>
> 12G before the drop and 250m after the drop/create/insert.

Have you been running vacuum and vacuum full?

What version of Postgresql are you running, and what OS are you on?