Re: Creating Index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Creating Index
Дата
Msg-id 19818.1065194783@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Creating Index  ("CN" <cnliou9@fastmail.fm>)
Список pgsql-sql
"CN" <cnliou9@fastmail.fm> writes:
> I thought I have got no more question in this thread, and I was wrong :-(
> Is the extra 300ms in UNION essential?

Dividing, it looks like the Append node is taking about 3 microseconds
per tuple, which seems kind of a lot considering it isn't really doing
anything.  I suspect though that most of this overhead is due to the
EXPLAIN ANALYZE instrumentation, and would in fact go away when you
are just running the query.
        regards, tom lane


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

Предыдущее
От: achill@matrix.gatewaynet.com
Дата:
Сообщение: Re: HeapTuple->t_tableOid==0 after SPI_exec
Следующее
От: Jeff Boes
Дата:
Сообщение: Re: Data type conversion