Re: UPDATE sql question

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Andrei Verovski <andreil1(at)mail(dot)starlett(dot)lv>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: UPDATE sql question
Date: 2003-07-28 18:16:12
Message-ID: Pine.LNX.4.33.0307281215490.19755-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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.

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Andrei Verovski (aka MacGuru) 2003-07-29 14:55:46 Strange problem starting PostgreSQL
Previous Message Josh Berkus 2003-07-28 17:11:31 Re: Accessing Postgres db from apache using PHP