stephen farrell <[EMAIL PROTECTED]> writes: > I'm having a problem with a queyr like: INSERT INTO FACT (x,x,x,x,x,x) > SELECT a.key,b.key,c.key,d.key,e.key,f.key from x,a,b,c,d,e,f where x=a > and x=b .... -- postgres7.4 is running out of memory. I'm not sure > why this would happen -- does it buffer the subselect before doing the > insert?
What does EXPLAIN show for the query? And we need to see the exact query and table definitions, not abstractions. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html