Re: Reducing expression evaluation overhead

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Reducing expression evaluation overhead
Дата
Msg-id 87d67d1dfc.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Reducing expression evaluation overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> > b) Instead of storing one of a small set of function pointers in every
> > node of every expression, wouldn't it make more sense to have a table
> > lookup from node type to function pointer?
> 
> That's pretty much what the ExecEvalExpr switch() does already, on most
> modern architectures.

Huh. <looks at the assembly on i386>. Indeed that's exactly what it's doing.
Amazing that a failed branch prediction in the wrong place can cause that huge
a penalty.

-- 
greg



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

Предыдущее
От: Manfred Spraul
Дата:
Сообщение: Re: WAL write of full pages
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [PERFORM] rapid degradation after postmaster restart