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.
ideas?
Thanks!
Stephane