Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eTsWM-0002zW-Be for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Dec 2017 16:56:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eTsWL-0004l6-Pe for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Dec 2017 16:56:05 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eTsWL-0004kv-GB for pgsql-hackers@lists.postgresql.org; Tue, 26 Dec 2017 16:56:05 +0000 Received: from smtprelay0109.b.hostedemail.com ([64.98.42.109] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eTsWI-0001Nv-5a for pgsql-hackers@postgresql.org; Tue, 26 Dec 2017 16:56:04 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay05.b.hostedemail.com (Postfix) with ESMTP id BFD6332AF9C; Tue, 26 Dec 2017 16:56:00 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::,RULES_HIT:41:69:355:379:599:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1541:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2553:2560:2563:2682:2685:2693:2828:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3352:3865:3866:3867:3868:3870:3871:3872:3873:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4605:5007:6119:6261:7903:8603:8957:9025:9121:10004:10400:10848:11232:11658:11914:12663:13069:13311:13357:13439:13894:13895:14764:14915:21080:21627:30054:30070:30090,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:1,LUA_SUMMARY:none X-HE-Tag: board45_3465ca486ae15 X-Filterd-Recvd-Size: 1988 Received: from alvin.alvh.no-ip.org (unknown [179.57.113.18]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf14.b.hostedemail.com (Postfix) with ESMTPA; Tue, 26 Dec 2017 16:56:00 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 0125311B5; Tue, 26 Dec 2017 13:55:57 -0300 (-03) Date: Tue, 26 Dec 2017 13:55:57 -0300 From: Alvaro Herrera To: Arthur Zakirov Cc: pgsql-hackers Subject: Re: [PROPOSAL] Shared Ispell dictionaries Message-ID: <20171226165557.w2zd3tdlr6gqq33b@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20171226164825.GA29922@zakirov.localdomain> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Arthur Zakirov wrote: > Implementation > -------------- > > It is necessary to change all structures related with IspellDict: > SPNode, AffixNode, AFFIX, CMPDAffix, IspellDict itself. They all > shouldn't use pointers for this reason. Others are used only during > dictionary building. So what are you going to use instead? > It would be good to store in a shared memory StopList struct too. Sure (probably a separate patch though). > All fields of IspellDict struct, which are used only during dictionary > building, will be move into new IspellDictBuild to decrease needed > shared memory size. And they are going to be released by buildCxt. > > Each dictionary will be stored in its own dsm segment. All that sounds reasonable. > The patch will be ready and added into the 2018-03 commitfest. So this will be a large patch not submitted to 2018-01? Depending on size/complexity I'm not sure it's OK to submit 2018-03 only -- it may be too late. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services