From: Tom Lane <tgl@sss.pgh.pa.us>
To: stephen farrell <sfarrell@almaden.ibm.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problem with insert into select...
Date: Thu, 20 Nov 2003 17:58:40 -0500
Message-ID: <7439.1069369120@sss.pgh.pa.us> (raw)
In-Reply-To: <3FBD2D8B.8020509@almaden.ibm.com>
References: <3FBD2D8B.8020509@almaden.ibm.com>
stephen farrell <sfarrell@almaden.ibm.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, sfarrell@almaden.ibm.com
Subject: Re: Problem with insert into select...
In-Reply-To: <7439.1069369120@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox