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