Обсуждение: full text search - dictionary caching

Поиск
Список
Период
Сортировка

full text search - dictionary caching

От
Tomasz Myrta
Дата:
Hello

Does Postgres have ability to keep .dict and .affix files cached
globally for all client sessions?

Every time I connect to test server - it takes 3 seconds to load 4MB
dictionary when executing first FTS query.

--
Regards,
Tomasz Myrta

Re: full text search - dictionary caching

От
Tom Lane
Дата:
Tomasz Myrta <jasiek@klaster.net> writes:
> Does Postgres have ability to keep .dict and .affix files cached
> globally for all client sessions?

No, there's no provision for that.

> Every time I connect to test server - it takes 3 seconds to load 4MB
> dictionary when executing first FTS query.

You might consider using connection pooling, so that you can re-use
a backend process that already has everything loaded in.

            regards, tom lane