Re: perfomance question - Mailing list pgsql-sql

From sad
Subject Re: perfomance question
Date
Msg-id 200403190927.43971.sad@bankir.ru
Whole thread Raw
In response to Re: perfomance question  (Josh Berkus <josh@agliodbs.com>)
Responses Re: perfomance question
List pgsql-sql
On Thursday 18 March 2004 21:38, you wrote:
> 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?

Really ! why ? :-)

I forgot to ask the second question:
How these updates affect a data storage ?
(does (b) cause physical update of f2 ?)




pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: perfomance question
Next
From: Adam Ruth
Date:
Subject: Re: perfomance question