Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with inserts from subselects - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problem with inserts from subselects
Date
Msg-id 6898.1082775736@sss.pgh.pa.us
Whole thread Raw
In response to Problem with inserts from subselects  (Tyler Ward <tjw19@columbia.edu>)
List pgsql-admin
Tree view 
Tyler Ward <tjw19@columbia.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

pgsql-admin by date:

Previous
From: banghe
Date:
Subject: Re: Problem with inserts from subselects
Next
From: Gaetano Mendola
Date:
Subject: Re: Real time replication of PG DBs accross two servers - any experiences?