Re: WIP: preloading of ispell dictionary

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-03-23T06:07:54Z
Lists: pgsql-hackers
Takahiro Itagaki wrote:
> Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 
>> I wrote some small patch, that allow preloading of  selected ispell
>> dictionary. It solve the problem with slow tsearch initialisation with
>> some language configuration.
>>
>> I afraid so this module doesn't help on MS Windows.
> 
> I think it should work on all platforms if we include it into the core.

It will work, as in it will compile and run. It just won't be any
faster. I think that's enough, otherwise you could argue that we
shouldn't have preload_shared_libraries option at all because it won't
help on Windows.

> 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?

Yeah, that would be better.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com