"Burgholzer, Robert (DEQ)" <Robert.Burgholzer@xxxxxxxxxxxxxxxx> writes: > That said, the time to restore is explainable, but is there something in > my tuning that is causing all of my memory to be eaten? That's normal behavior. A working Linux/Unix system *should* have near zero free memory. If it doesn't, either the filesystem cache is failing to do its job, or you recently booted the machine and it hasn't had a chance to fill the cache, or you bought way more RAM than your workload has any use for. > We seem to have some undiagnosed issue whereby opening and closing large > files on the system leaves a lot in the cache -- I am guessing that this > is my culprit and NOT my pg tuning? That's called "it's working correctly". If you want to get an accurate picture of whether the system is under memory pressure, you need to discount filesystem cache, and also pay attention to whether anything much has been pushed out to swap. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
