Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of Memory and Configuration Problems (Big Computer) - Mailing list pgsql-general

From Stephen Frost
Subject Re: Out of Memory and Configuration Problems (Big Computer)
Date
Msg-id 20100528132024.GR21875@tamriel.snowman.net
Whole thread Raw
In response to Out of Memory and Configuration Problems (Big Computer)  (Tom Wilcox <hungrytom@googlemail.com>)
List pgsql-general
Tree view 
* Tom Wilcox (hungrytom@googlemail.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
Attachment

pgsql-general by date:

Previous
From: Joachim Worringen
Date:
Subject: Re: INSERTing lots of data
Next
From: Dbarrett
Date:
Subject: PostgreSQL DBA Opening