WIP: preloading of ispell dictionary
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-03-19T10:38:58Z
Lists: pgsql-hackers
Attachments
- preload.diff (application/octet-stream) patch
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