Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Adam RuthDate: 2004-03-19 07:14:29
Subject: Re: perfomance question
Previous:From: Josh BerkusDate: 2004-03-18 18:38:30
Subject: Re: perfomance question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group