On Thursday 20 November 2003 21:04, stephen farrell wrote: > 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.
When this has happened to me it's always been because I've got an unconstrained join due to pilot error. Try an EXPLAIN on the select part and see if that pops up anything. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html