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