Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Damien Clermonté <damien(dot)clermonte(at)free(dot)fr>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword
Date: 2001-07-08 22:15:31
Message-ID: Pine.LNX.4.30.0107090007230.677-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane writes:

> Since pg_hba.conf is re-read on every connection, I've always thought
> it was pretty bogus to bulk it up with that much internal documentation.

Maybe it should be cached in memory and only be re-read on request
(SIGHUP). Parsing that file every time is undoubtedly a large fraction of
the total connection startup time.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2001-07-09 01:26:33 ADD CONSTRAINT behaviour question
Previous Message Bruce Momjian 2001-07-08 21:20:24 Re: Happy Anniversary

Browse pgsql-patches by date

  From Date Subject
Next Message Ola Sundell 2001-07-08 22:19:21 UpdateableResultSets and concurrency.
Previous Message Tom Lane 2001-07-08 20:49:36 Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword