At 02:02 AM 10/24/03 -0300, Claudio Lapidus wrote:
>Hello Adam
>
>I had a similar problem, although my table is much smaller, it keeps around
>50K rows, I think if you are inserting 10 by second you have 10*3600*24*7,
>that's about 6 million records. Also I'm assuming here that you also delete
>constantly any record being more than one week old, is this correct or do
>you delete all rows once a week and start over with the table empty?
Every night at midnight I delete everything over 7 days old.
>Essentially what we do here is vacuum very frequently (every five minutes or
>so), being very careful about FSM settings and run a VACUUM FULL and a
>REINDEX once a week, that keeps the table performance within limits. We
>never run CLUSTER for that.
I'm running pg_autovac on my database, and 7.4 (updating to beta 5 today to
see if it improves things).
--- Adam Kavan
--- akavan@cox.net
