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.
