From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | WIP: preloading of ispell dictionary |
Date: | 2010-03-19 10:38:58 |
Message-ID: | 162867791003190338r1c1efa1doea253d4f3c0d4582@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
I wrote some small patch, that allow preloading of selected ispell
dictionary. It solve the problem with slow tsearch initialisation with
some language configuration.
This patch is most simple - simpler than variant with shared memory
and it is usable on Linux platform.
I registered some issues about access to different king of memory :(.
The local memory is the best, than shared_memory and then virtual
memory. Queries with preloaded dictionary are about 20% slower (but
still good enough). It depend on platform (and language sure) - I
afraid so this module doesn't help on MS Windows.
Tested on 64bit Fedora Linux - probably on 32bit these issues will be smaller.
I would to add this patch to next commitfest.
can somebody test it for different platforms and different languages than Czech?
Regards
Pavel Stehule
Attachment | Content-Type | Size |
---|---|---|
preload.diff | application/octet-stream | 22.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-03-19 10:41:22 | pgsql: Reset btpo.xact following recovery of btree delete page. |
Previous Message | Csaba Nagy | 2010-03-19 08:59:23 | Re: Getting to beta1 |