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

Re: Out of Memory and Configuration Problems (BigComputer)

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 (BigComputer)
Date: 2010-05-28 13:20:24
Message-ID: 20100528132024.GR21875@tamriel.snowman.net (view raw or flat)
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

pgsql-general by date

Next:From: Peter GeogheganDate: 2010-05-28 13:33:25
Subject: Re: PostgreSQL DBA Opening
Previous:From: Joachim WorringenDate: 2010-05-28 13:17:33
Subject: Re: INSERTing lots of data

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