| From: | Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: WIP: preloading of ispell dictionary |
| Date: | 2010-03-23 00:57:31 |
| Message-ID: | 20100323095730.992C.52131E4D@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
We should continue to research shared memory or mmap approaches.
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?
BTW, SimpleAllocContextCreate() is not used at all in the patch.
Do you still need it?
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-03-23 01:29:38 | Re: Standalone backends run StartupXLOG in an incorrect environment |
| Previous Message | Peter Eisentraut | 2010-03-22 23:48:04 | Re: Re: [COMMITTERS] pgsql: Prevent the injection of invalidly encoded strings by PL/Python |