Re: Problem with inserts from subselects

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with inserts from subselects
Дата
Msg-id 6898.1082775736@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with inserts from subselects  (Tyler Ward <tjw19@columbia.edu>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: banghe
Дата:
Сообщение: Re: Problem with inserts from subselects
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Real time replication of PG DBs accross two servers - any experiences?