Nick <t32(at)2thebatcave(dot)com> wrote:
> Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>
>> I've not seen anything remotely like that. I wonder what's
>> different....
>
> I did a test with the same postgres build (and autovacuum_naptime
> = 1 as well) on the same OS with only the system databases
> (postgres, template0, template1), and after the weekend the memory
> utilization was acceptable:
That's probably it. Our shop normally has just one application
database in a cluster, and I can't think of any clusters with more
than three or four. It sounds like there might be some sort of
memory leak when a vacuum worker switches databases.
-Kevin