Re: [GENERAL] Time Travel
| От | Bruce Momjian |
|---|---|
| Тема | Re: [GENERAL] Time Travel |
| Дата | |
| Msg-id | 199807121539.LAA02807@candle.pha.pa.us обсуждение |
| Ответ на | Time Travel (Andy <a_widodo@natrindo.co.id>) |
| Список | pgsql-general |
> 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)
В списке pgsql-general по дате отправления: