Tomasz Myrta <jasiek@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
