pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Arthur Zakirov <a.zakirov@postgrespro.ru>
To: Andres Freund <andres@anarazel.de>
Cc: Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: [PROPOSAL] Shared Ispell dictionaries
Date: Wed, 7 Mar 2018 10:55:29 +0100
Message-ID: <3195b6e6-4026-d7e2-ffa9-3780bc3cca6f@2ndquadrant.com> (raw)
In-Reply-To: <20180307085553.GA5126@zakirov.localdomain>
References: <20171226164825.GA29922@zakirov.localdomain>
	<20171231152811.GA4233@arthur.localdomain>
	<20180107190526.GA27803@arthur.localdomain>
	<d12d9395-922c-64c9-c87d-dd0e1d31440e@2ndquadrant.com>
	<CAKNkYnzQ8SJCiFityn+4B_0zZKOmfw1R1M0KHXaFF8BYf9DJ=g@mail.gmail.com>
	<20180124172039.GA11210@zakirov.localdomain>
	<20180125152646.3b4d2850@wp.localdomain>
	<20180125165156.GA21129@zakirov.localdomain>
	<20180207162828.GA28046@zakirov.localdomain>
	<20180302043149.tn2xjgt2vcigknhe@alap3.anarazel.de>
	<20180307085553.GA5126@zakirov.localdomain>



On 03/07/2018 09:55 AM, Arthur Zakirov wrote:
> Hello Andres,
> 
> On Thu, Mar 01, 2018 at 08:31:49PM -0800, Andres Freund wrote:
>> Is there any chance we can instead can convert dictionaries into a form
>> we can just mmap() into memory?  That'd scale a lot higher and more
>> dynamicallly?
> 
> To avoid misunderstanding can you please elaborate on using mmap()? The
> DSM approach looks like more simple and requires less code. Also DSM may
> use mmap() if I'm not mistaken.
> 

I think the mmap() idea is that you preprocess the dictionary, store the
result in a file, and then mmap it when needed, without the expensive
preprocessing.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




view thread (108+ messages)  latest in thread

Message-ID: <3195b6e6-4026-d7e2-ffa9-3780bc3cca6f@2ndquadrant.com>
Permalink:  ../3195b6e6-4026-d7e2-ffa9-3780bc3cca6f@2ndquadrant.com/
Also on:    postgresql.org/message-id/3195b6e6-4026-d7e2-ffa9-3780bc3cca6f@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com, a.zakirov@postgrespro.ru, andres@anarazel.de, i.kurbangaliev@postgrespro.ru
  Subject: Re: [PROPOSAL] Shared Ispell dictionaries
  In-Reply-To: <3195b6e6-4026-d7e2-ffa9-3780bc3cca6f@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox