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: (view raw, whole thread or download thread mbox)
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-2018 The PostgreSQL Global Development Group