Re: Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)
Дата
Msg-id 20060608194637.GB20220@surnet.cl
обсуждение исходный текст
Ответ на Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:

> A possible objection to this is that running a query inside a
> subtransaction might have different/worse performance than running it
> at top level.  I don't recall any severe bottlenecks of that kind but
> that doesn't mean there aren't any (Alvaro, any comments?)

Nope, nothing that I recall.  Maybe make sure to generate the Xid of the
subtransaction before starting the EXPLAIN itself (so that there is no
pg_subtrans I/O pending, etc)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)
Следующее
От: "Milen Kulev"
Дата:
Сообщение: PG 8.2