About updates

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: About updates
Date: 2006-03-10 15:46:39
Message-ID: 44119F5F.4050501@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

postgresql 8.0.1, in a plpgsql function

To update columns' values in a table (without OID), if I ran:
1. "update table1 set col1 = ..., col2 = ... ... col100 ="

or
2.
"update table1 set col1 = "
...
"update table1 set col100 = "

way 1 only has one disk I/O, right? While way 2 is more time consuming
since there is disk I/O when a update is ran.

Thanks a lot,
Ying

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2006-03-10 15:56:01 Re: in Pl/PgSQL, do commit every 5000 records
Previous Message Tom Lane 2006-03-10 15:08:30 Re: panic during pgsql startup