Re: Performance problems testing with Spamassassin 3.1.0

Поиск
Список
Период
Сортировка
Искать
От
PFC
Тема
Re: Performance problems testing with Spamassassin 3.1.0
Дата
Msg-id
op.suy6mejzth1vuj@localhost
Ответ на
Список
Дерево обсуждения
Re: Performance problems testing with Spamassassin 3.1.0 Bayes module. "Merlin Moncure" <merlin.moncure@rcsonline.com>

> What I really want to do is have the token array available as a record
> so that I can query against it, but not have it take up the resources of
> a real table.  If I could copy from an array into a record then I can
> even get rid of the loop.  Anyone have any thoughts on how to do this?

	You could make a set-returning-function (about 3 lines) which RETURNs  
NEXT every element in the array ; then you can use this SRF just like a  
table and SELECT from it, join it with your other tables, etc.
В списке pgsql-performance по дате отправления
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Indexed views.
От: Laszlo Hornyak
Дата:
Сообщение: Re: Indexed views.
FAQ