Horton

Re: [HACKERS] UPDATE performance degradation (6.5.1)

Zeugswetter Andreas <andreas.zeugswetter@telecom.at>

View thread
From: Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
To: "'Oleg Bartunov'" <oleg@sai.msu.su>
Cc: "'hackers@postgresql.org'" <hackers@postgresql.org>
Date: 1999-07-27T14:57:06Z
Lists: pgsql-hackers 
> This is for table with one row  after a lot of updates.
> Too much. vacuum analyze this table was a good  medicine !
> Is this a design problem ? 
> 
In PostgreSQL an update always adds a new row to the table.
The old rows get eliminated by vacuum that is the whole business of vacuum.
There has been some discussion for implementing row reuse,
but that is a major task.

Andreas