pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: stephen farrell <sfarrell@almaden.ibm.com>
To: pgsql-performance@postgresql.org
Subject: Problem with insert into select...
Date: Thu, 20 Nov 2003 13:04:29 -0800
Message-ID: <3FBD2C5D.8000706@almaden.ibm.com> (raw)

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.





view thread (6+ messages)  latest in thread

Message-ID: <3FBD2C5D.8000706@almaden.ibm.com>
Permalink:  ../3FBD2C5D.8000706@almaden.ibm.com/
Also on:    postgresql.org/message-id/3FBD2C5D.8000706@almaden.ibm.com

 · 

reply

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: sfarrell@almaden.ibm.com
  Subject: Re: Problem with insert into select...
  In-Reply-To: <3FBD2C5D.8000706@almaden.ibm.com>

* 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