Re: Apache2 PostgreSQL http authentication - Mailing list pgsql-performance

From Tino Wildenhain
Subject Re: Apache2 PostgreSQL http authentication
Date
Msg-id 470A645C.1080405@wildenhain.de
Whole thread Raw
In response to Re: Apache2 PostgreSQL http authentication  ("Magnus Hagander" <magnus@hagander.net>)
Responses Re: Apache2 PostgreSQL http authentication
List pgsql-performance
Magnus Hagander schrieb:
> I'd consider having a small daemon LISTENing for NOTIFYs that you send by triggers whenever the table has changed.
That'llmake sure it only dumps if something actually changed. And you can also implement some ratelimiting if needed. 
Do you really think such a homegrown solution will be more
performant then just accessing postgres? If you have
many users the lookup time in a .htaccess/.htpasswd is not for
free either.

Regards
Tino

pgsql-performance by date:

Previous
From: "Josh Tolley"
Date:
Subject: Re: postgresql on NFS.. recommended? not recommended?
Next
From: Magnus Hagander
Date:
Subject: Re: Apache2 PostgreSQL http authentication