Re: [SQL] Slow Inserts Again

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] Slow Inserts Again
Дата
Msg-id 28434.925775866@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] Slow Inserts Again  ("Rudy Gireyev" <rgireyev@cnmnetwork.com>)
Список pgsql-sql
"Rudy Gireyev" <rgireyev@cnmnetwork.com> writes:
> Is it at all possible that the optimizer is responsible for this behaviour?

Not in the sense that it might be choosing a bad plan --- there is only
one way to insert a tuple ;-).  Size of the table doesn't matter.

If the problem is indeed some kind of memory leak, the optimizer is as
likely a place for the leak as any other, I suppose.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Frank Morton"
Дата:
Сообщение: Re: [SQL] Slow Inserts Again
Следующее
От: "G. Anthony Reina"
Дата:
Сообщение: Granting select on ALL tables at once