Re: full text search - dictionary caching - Mailing list pgsql-performance

From Tom Lane
Subject Re: full text search - dictionary caching
Date
Msg-id 27009.1235579774@sss.pgh.pa.us
Whole thread Raw
In response to full text search - dictionary caching  (Tomasz Myrta <jasiek@klaster.net>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: henk de wit
Date:
Subject: Re: PostgreSQL block size for SSD RAID setup?
Next
From: PFC
Date:
Subject: Re: PostgreSQL block size for SSD RAID setup?