Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 25 Feb 2009 11:36:14 -0500
- Message-id: <27009.1235579774@sss.pgh.pa.us> <text/plain>
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
- References:
- full text search - dictionary caching
- From: Tomasz Myrta
- full text search - dictionary caching
- Prev by Date: Re: PostgreSQL block size for SSD RAID setup?
- Next by Date: Re: PostgreSQL block size for SSD RAID setup?
- Previous by thread: full text search - dictionary caching
- Next by thread: PostgreSQL block size for SSD RAID setup?
- Indexes: