WIP: preloading of ispell dictionary

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

Responses

Browse pgsql-hackers by date

  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