Re: pg_hba.conf caching

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_hba.conf caching
Дата
Msg-id 200107232135.f6NLZYf21603@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_hba.conf caching  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-patches
> On Fri, Jul 20, 2001 at 08:31:02PM -0400, Bruce Momjian wrote:
> > Attached is a patch that caches the non-comment contents of pg_hba.conf
> > as a List of list of tokens.  It uses that to test each authentication
>
>   Means it cached are tokens only (and it save lexical analyze for
> postmaster children), and final parsing (syntax analyze) running always?
>
>  If I'm right: why not store to memory some final structs with config
> file content? And for example things like 'strcmp(token, "password")'
> run only once during postmaster startup.

The patch will tokenize the file, discard comments, and store the tokens
as a List of Lists, one List per line.  We could go with data structures
and eliminate the strncmp of fixed strings and conversion of inet
addresses to  inet values but it doesn't seemw worth it.  Certainly, now
that the code is completed overhauled, doing something like that will be
easier.  The hba.c code clearly needed an overhaul anyway.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

В списке pgsql-patches по дате отправления:

Предыдущее
От: Neil Padgett
Дата:
Сообщение: Patch to allow multiple table locks in "Unison"
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Merging JDBC1 and JDBC2 similarities