Thread: full text search - dictionary caching

full text search - dictionary caching

From
Tomasz Myrta
Date:
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

From
Tom Lane
Date:
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