On Mon, Mar 2, 2015 at 4:36 PM, Greg Stark <st...@mit.edu> wrote: > > So I didn't get the memo about SFRM_Materialize. Here's a rewrite of this > 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.
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: TopMemoryContext: 8192 total in 1 blocks; 5264 free (1 chunks); 2928 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 956300288 total in 126 blocks; 1694136 free (82 chunks); 954606152 used The lines in my pg_hba.conf don't have any databases or roles listed so there shouldn't be any tokens taking up space either. I just copied this line 25,000 times: local all all trust -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
