Skip site navigation (1) Skip section navigation (2)

Problem with insert into select...

From: stephen farrell <sfarrell(at)almaden(dot)ibm(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Problem with insert into select...
Date: 2003-11-20 21:09:31
Message-ID: 3FBD2D8B.8020509@almaden.ibm.com (view raw or flat)
Thread:
Lists: pgsql-performance
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?

Things are pretty big scale: 3gb ram, 32768 shared buffers, 700gb disk,
millions of rows in the tables.





Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2003-11-20 22:58:40
Subject: Re: Problem with insert into select...
Previous:From: stephen farrellDate: 2003-11-20 21:04:29
Subject: Problem with insert into select...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group