Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSWEq-0004J4-FV for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Mar 2015 19:42:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YSWEp-0002Xk-SL for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Mar 2015 19:42:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YSWEn-0002Uc-Lb for pgsql-hackers@postgresql.org; Mon, 02 Mar 2015 19:42:45 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSWEk-0005aA-GE for pgsql-hackers@postgresql.org; Mon, 02 Mar 2015 19:42:44 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id C508B5F79B; Mon, 2 Mar 2015 14:42:41 -0500 (EST) Date: Mon, 2 Mar 2015 14:42:41 -0500 From: Stephen Frost To: Greg Stark Cc: Haribabu Kommi , Pavel Stehule , Tom Lane , Tomas Vondra , PostgreSQL Hackers Subject: Re: Providing catalog view to pg_hba.conf file - Patch submission Message-ID: <20150302194241.GW29780@tamriel.snowman.net> References: <20150227195529.GS29780@tamriel.snowman.net> <12545.1425072391@sss.pgh.pa.us> <20150228004101.GV29780@tamriel.snowman.net> <20150302133417.GL29780@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="wg2zgDM1gLxA7pbN" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-45-generic (x86_64) X-Uptime: 14:41:55 up 39 days, 19:31, 9 users, load average: 0.28, 0.22, 0.19 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --wg2zgDM1gLxA7pbN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Greg Stark (stark@mit.edu) wrote: > On Mon, Mar 2, 2015 at 4:36 PM, Greg Stark wrote: > > > > So I didn't get the memo about SFRM_Materialize. Here's a rewrite of th= is using that interface which seems to test ok up to 100k. At that point I = start running into memory errors on reading the HBA file so I guess that's = an indication that's large enough to stop worrying about it. >=20 > Hm. I'm wondering why I'm getting out of memory errors now with just > 25k lines in pg_hba.conf. It looks like the HbaLine struct is "only" > 472 bytes so the list should only be occupying about 11MB. In fact > it's occupying about a gigabyte: Uh, maybe because it's trying to allocate over 1GB and palloc() doesn't support that? Thanks, Stephen --wg2zgDM1gLxA7pbN Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJU9L0xAAoJEO1sijiDR2RV4zMQAJeO323spbYN4HOg4cDjnk6X pKX4d0/tCC7CBFS/9+kmKRPSqSsnXkmyUEtYwu30VCdYAJmgrfqeHAed69ZA7pGY Bey05HXnh1w1vJJ26z6ur4PrmA9cT3wofI2XD4Yb4pF/33xggdRouYtytk2n4g3z 2NEz+epJq2lGryAbBv578ay0/Mh3MzCNerxKl5UrbfY1L7eiRv/pHjrtjSCJVvKd Lk6QdDRu/PRZrmVxIpkYGVJs0701xihQ6ggH00/Zc2F2liISBl9gTuqFP8sxlNj+ txtiwxluDbA31S3GRLkfNfFbmfu6r+62FsiMj2wEgs43ybDCwCFu7PBZd2SwgpH8 Zz65DbOAHiGqbgVPeqBN7smcuXwL0Us9L87NgsMX1VjP7W2yOBonZxMiLPdQc+PH h7U4eFVdt7QY7CRHOZUOUCX3Su/sIvDfodBFmVExyoGyr7HTDSX7JtJhLuuVSRZl 6V/ajTCh+5RkrLxh89nStqL3vAy+oEEA4MAMK2ESsMrZKFiGWQSFtzKObZOua0EB M9+L9NEbLFulQIPqtCuKSuelX2eZqRP85PwcOT5ZemmZ4YRkMm1gbyITPtzayzEW 5O6q77LKGRHEW5a3gOnrDkXfPMlQxDT3YqooaR07IagPRhcqDGng6dgQKzdqozRa p5LJjMfRQJheIwI+xh4w =m2+Q -----END PGP SIGNATURE----- --wg2zgDM1gLxA7pbN--