Re: perfomance question

From: sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: perfomance question
Date: 2004-03-19 06:27:43
Message-ID: 200403190927.43971.sad@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adam Ruth 2004-03-19 07:14:29 Re: perfomance question
Previous Message Josh Berkus 2004-03-18 18:38:30 Re: perfomance question