Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE sql question - Mailing list pgsql-php

From scott.marlowe
Subject Re: UPDATE sql question
Date
Msg-id Pine.LNX.4.33.0307281215490.19755-100000@css120.ihs.com
Whole thread Raw
In response to UPDATE sql question  (Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>)
List pgsql-php
Tree view 
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.

pgsql-php by date:

Previous
From: "bruce"
Date:
Subject: Re: Accessing Postgres db from apache using PHP
Next
From: Andrei Verovski (aka MacGuru)
Date:
Subject: Strange problem starting PostgreSQL