> We use Prostgres 6.3.2 for our production system, but the Postgres
> tables is growing when the data updated (time travel?). Could any one
> help me to stop this time travel problem, since it make our system slow,
> and data corrputed frequently, our table size is about 150 MB (after
> vacuum), and 210 MB (before vacuum). The table is updated about 100
> thousands time per day, and we do the daily vacuum for the table.
I have talked to Vadim about auto-reusing superceeded rows. It is on
the todo list. Currently, only vacuum removes old rows.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)