jason nordwick <[EMAIL PROTECTED]> writes: > ERROR: out of memory > DETAIL: Failed on request of size 856. > CONTEXT: SQL statement "create table gwt as select * from gworktick" > PL/pgSQL function "processadd" line 30 at SQL statement
What PG version? What does "explain select * from gworktick" say? Can you get explain analyze results, or does that fail with the same error? > work_mem = 512000 # min 64, size in KB This could well be excessive for complicated views. You're promising that you can provide half a gig of RAM for *each* sort or hash in the plan. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly