[HACKERS] Re: Transactions vs speed.

2001-01-13 Thread Alfred Perlstein
* mlw <[EMAIL PROTECTED]> [010113 19:37] wrote: > Alfred Perlstein wrote: > > > > * mlw <[EMAIL PROTECTED]> [010113 17:19] wrote: > > > I have a question about Postgres: > > > > > > Take this update: > > > update table set field = 'X' ; > > > > > > > > > This is a very expensive function wh

[HACKERS] Re: Transactions vs speed.

2001-01-13 Thread mlw
Alfred Perlstein wrote: > > * mlw <[EMAIL PROTECTED]> [010113 17:19] wrote: > > I have a question about Postgres: > > > > Take this update: > > update table set field = 'X' ; > > > > > > This is a very expensive function when the table has millions of rows, > > it takes over an hour. If I d