| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | a_widodo(at)natrindo(dot)co(dot)id (Andy) |
| Cc: | pgsql-general(at)postgreSQL(dot)org, vadim(at)sable(dot)krasnoyarsk(dot)su (Vadim B(dot) Mikheev) |
| Subject: | Re: [GENERAL] Time Travel |
| Date: | 1998-07-12 15:39:54 |
| Message-ID: | 199807121539.LAA02807@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Doliov | 1998-07-12 18:33:16 | Re: [NOVICE] Max length string question (fwd) |
| Previous Message | Herouth Maoz | 1998-07-12 11:49:04 | Re: [GENERAL] Time Travel |