2010/3/23 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 2010/3/23 Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>:
>
>> The fundamental issue seems to be in the slow initialization of
>> dictionaries. If so, how about adding a pre-complile tool to convert
>> a dictionary into a binary file, and each backend simply mmap it?
>
> It means loading about 25MB from disc. for every first tsearch query -
> sorry, I don't believe can be good.
The operating system's VM subsystem should make that a non-problem.
"Loading" is also not the word I would use to indicate what mmap does.
Nicolas