Re: full text search - dictionary caching

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: full text search - dictionary caching
Date: 2009-02-25 16:36:14
Message-ID: 27009.1235579774@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tomasz Myrta <jasiek(at)klaster(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2009-02-25 18:28:31 Re: PostgreSQL block size for SSD RAID setup?
Previous Message henk de wit 2009-02-25 16:13:34 Re: PostgreSQL block size for SSD RAID setup?