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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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