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.
/Magnus
> ------- Original Message -------
> From: "Jeffrey Brower" <Jeff@PointHere.net>
> To: "'D'Arcy J.M. Cain'" <darcy@druid.net>
> Sent: 07-10-07, 22:58:29
> Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication
>
> Using a cron task was my first thought. Unfortunately, new users are given
> a logon that they immediately use. I thought about shelling out and
> updating a password file on an on-demand basis but I am not sure if that is
> such a great idea either - especially since users can change their passwords
> and renew their logons at will as well.
>
> Jeff
>
>
> -----Original Message-----
> From: D'Arcy J.M. Cain [mailto:darcy@druid.net]
> Sent: Sunday, October 07, 2007 4:45 PM
> To: Jeff@PointHere.net
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication
>
> On Sun, 7 Oct 2007 09:14:43 -0400
> "Jeffrey Brower" <Jeff@PointHere.net> wrote:
> > As I say, from a performance point of view, I would really like to
> > know if there is anything I can do to make sure that postgres is
> > performing as quickly as possible under apache2 so that my http
> > authentication is not impacted too significantly.
>
> How often does the user information change? Can you simply create standard
> Apache password files from cron during non-busy hours?
> Sometimes the lower tech solution works best.
>
> --
> D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves
> http://www.druid.net/darcy/ | and a sheep voting on
> +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>