Re: UPDATE sql question

On Mon, 28 Jul 2003, Andrei Verovski wrote:

> Hi,
>
> What exactly will happen if UPDATE sql statement instructs to update
> some columns with the same values as already in the database? Will
> Postgres update only different values or it will simply modify all
> columns listed in UPDATE sql?

It will update the columns.  Which means lots of dead tuples, which means
vacuuming.