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

Re: Problem with inserts from subselects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tyler Ward <tjw19(at)columbia(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org, Tyler Ward <tward(at)janestcapital(dot)com>
Subject: Re: Problem with inserts from subselects
Date: 2004-04-24 03:02:16
Message-ID: 6898.1082775736@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Tyler Ward <tjw19(at)columbia(dot)edu> writes:
> I'm using postgres 7.3.x (the default installed on Fedora Core 1) and 
> I'm running into a serious
> bug in the insert performance.

Could we see EXPLAIN ANALYZE output from all three cases?  I'd have
expected "INSERT ... SELECT foo" to generate the same plan as
"SELECT foo", but it sounds like you're getting something different.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-04-24 10:17:17
Subject: Re: Real time replication of PG DBs accross two servers - any experiences?
Previous:From: Photo ResearchersDate: 2004-04-23 19:43:04
Subject: Follow-up: compiling 7.4 --with-java

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