Postgres Pro
Downloads
Home   >   mailing lists

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

From Tomasz Myrta
Subject full text search - dictionary caching
Date
Msg-id go360g$2aft$1@news.hub.org
Whole thread Raw
Responses Re: full text search - dictionary caching  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Hello

Does Postgres have ability to keep .dict and .affix files cached
globally for all client sessions?

Every time I connect to test server - it takes 3 seconds to load 4MB
dictionary when executing first FTS query.

--
Regards,
Tomasz Myrta

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL
Next
From: henk de wit
Date:
Subject: PostgreSQL block size for SSD RAID setup?