Re: Out of Memory and Configuration Problems (Big Computer)

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Wilcox <hungrytom(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory and Configuration Problems (Big Computer)
Date: 2010-05-28 13:20:24
Message-ID: 20100528132024.GR21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Tom Wilcox (hungrytom(at)googlemail(dot)com) wrote:
> UPDATE tbl SET f1 = COALESCE(f2,'') || ' ' || COALESCE(f3);
>
> Can anyone suggest reasons why I might be running out of memory on such
> a simple query?

Do you have any triggers on that table? Or FK's?

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2010-05-28 13:33:25 Re: PostgreSQL DBA Opening
Previous Message Joachim Worringen 2010-05-28 13:17:33 Re: INSERTing lots of data