mlw <[EMAIL PROTECTED]> writes:
> 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 dump the database, and process the data with
> perl, then reload the data, it takes minutes. Most of the
* 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 dump the database, and process the data wit
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 dump the database, and process the data with
perl, then reload the data, it takes minutes. Most of the ti