| From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
|---|---|
| To: | Andy <a_widodo(at)natrindo(dot)co(dot)id> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Time Travel |
| Date: | 1998-07-12 11:49:04 |
| Message-ID: | l03110709b1ce52c2b087@[147.233.159.109] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 14:34 +0300 on 12/7/98, Andy wrote:
> 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.
Explain: does the table grow relative to what it is supposed to contain
even *after* you do the vacuum? Because growing prior to vacuum is
expected. Nothing is actually deleted until vacuum is performed.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-07-12 15:39:54 | Re: [GENERAL] Time Travel |
| Previous Message | Andy | 1998-07-12 11:34:29 | Time Travel |