Skip site navigation (1) Skip section navigation (2)

Re: WIP: preloading of ispell dictionary

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: preloading of ispell dictionary
Date: 2010-03-24 14:01:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Pavel Stehule wrote:
> 2010/3/24 Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>:
> > Pavel Stehule wrote:
> >
> >> Personally I dislike idea some dictionary precompiler - it is next
> >> application for maintaining and maybe not necessary.
> >
> > That's the sort of thing that can be done when first required by any
> > backend and the results saved in a file for other backends to mmap().
> > It'd probably want to be opened r/w access-exclusive initially, then
> > re-opened read-only access-shared when ready for use.
> >
> > My only concern would be that the cache would want to be forcibly
> > cleared at postmaster start, so that "restart the postmaster" fixes any
> > messsed-up-cache issues that might arise (not that they should) without
> > people having to go rm'ing in the datadir. Even if Pg never has any bugs
> > that result in bad cache files, the file system / bad memory / cosmic
> > rays / etc can still mangle a cache file.
> >
> > BTW, mmap() isn't an issue on Windows:
> > ?
> > It's spelled CreateFileMapping, but otherwise is fairly similar, and is
> > perfect for this sort of use.
> >
> > A shared read-only mapping of processed-and-cached tsearch2 dictionaries
> > would save a HUGE amount of memory if many backends were using tsearch2
> > at the same time. I'd make a big difference here.
> >
> If you know this area well, please, enhance my first patch. I am not
> able to oppose to Tom, who has a clean opinion on this patch :(

Should we add a TODO?

  Bruce Momjian  <bruce(at)momjian(dot)us>

  PG East:

In response to


pgsql-hackers by date

Next:From: Pavel StehuleDate: 2010-03-24 14:14:40
Subject: Re: WIP: preloading of ispell dictionary
Previous:From: Fujii MasaoDate: 2010-03-24 13:36:33
Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group