TSearch2 performance issue?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема TSearch2 performance issue?
Дата
Msg-id 424B7529.3030807@familyhealth.com.au
обсуждение исходный текст
Ответы Re: TSearch2 performance issue?  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
I see this in my PQA analyzed PostgreSQL log:

######## Slowest queries
select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid 
= $1

It's my number one slowest query apparently!

Can that lookup perhaps be cached in some way?

I notice that there is no unique index on the oid column, but that 
shouldn't matter for performance since there are only like 6 rows in 
that table.

Also, will this work with default_with_oids = false?  (When the schema 
is initialised.)

Chris



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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: when using a bound cursor, error found..
Следующее
От: Neil Conway
Дата:
Сообщение: Hash vs. HashJoin nodes