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 Mendola||Date: 2004-04-24 10:17:17|
|Subject: Re: Real time replication of PG DBs accross two servers - any experiences?|
|Previous:||From: Photo Researchers||Date: 2004-04-23 19:43:04|
|Subject: Follow-up: compiling 7.4 --with-java|