Peter Erickson <redlamb@xxxxxxxxxxx> writes: > Thanks. Out of curiosity, if memory exhaustion was the problem, any idea > why the task manager would show that I'm only using 1.2GB of the 3GB of > memory? Well, it would've failed to allocate the next copy of the string that it needed ... and I think also we try to keep the output buffer size at a power of 2, so it might have been asking for 2GB for the output buffer. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general