Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group