Magnus Hagander schrieb:
I'd consider having a small daemon LISTENing for NOTIFYs that you send by triggers whenever the table has changed. That'll make 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
