Re: perfomance question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: perfomance question
Date
Msg-id 200403181038.30116.josh@agliodbs.com
Whole thread Raw
In response to perfomance question  (sad <sad@bankir.ru>)
Responses Re: perfomance question  (sad <sad@bankir.ru>)
List pgsql-sql
Sad,

> what are perfomance difference bitween
> a)  update t1 set f1 = 'x', f2 = 'y';
> b)  update t1 set f1 = 'x', f2 = f2;
> c)  update t1 set f1 = 'x';
> ?

Not a lot.  Why don't you try it?

-- 
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date format issue
Next
From: sad
Date:
Subject: Re: perfomance question