On Tue, Sep 30, 2008 at 3:33 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote: > Hi. > > 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. > > I'm thinking to schedule the command during low load moments after > forcing a sync command. > > I wonder if this can cause pgsql problems of any kind. Any idea?
Yes, it can. Postgres relies heavily on the OS' file system cache, if you wipe it out, you're going to have quite an I/O storm on a large database. What are you trying to accomplish? By itself, sync will flush all dirty file system blocks to disk and leave them in memory. -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general