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

Reply via email to