If its the OS cache the kernel ought to free the memory when there is something else worth caching. Its not a big deal if the cache is full so long as the system still performs well.
On Tue, Sep 30, 2008 at 9:51 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote: > Tom Lane ha scritto: > > Denis Gasparin <[EMAIL PROTECTED]> writes: > > > >> I'm evaluating to issue the drop_caches kernel command (echo 3 > > >> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory > >> entries and inodes. > >> > > > > Why in the world would you think that's a good idea? > > > > regards, tom lane > > > > > We see cached memory growing on constant base, even if there are no > connections to database. > > We have some tables that are truncated and reloaded with updated data on > regular basis (3,4 days). > > It seems like postgres or the operating system (linux) is keeping in > cache that old data even if it has been deleted. > > We're searching a way to free that memory without shutting down pgsql. > > Thank you for your help, > Denis > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
