Re: avoiding file system caching of a table - Mailing list pgsql-general

From Tom Lane
Subject Re: avoiding file system caching of a table
Date
Msg-id 12020.1392689859@sss.pgh.pa.us
Whole thread Raw
In response to Re: avoiding file system caching of a table  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Jeff Janes <jeff.janes@gmail.com> writes:
> If you told postgresql to tell the kernel not to cache the data it reads,
> how would this help?

I seem to recall also that O_DIRECT disables optimizations we definitely
want, like read-ahead.  So it could come out a loser independently of
any what's-in-cache concerns.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deleted files still open long after droping a database
Next
From: Gabriel Sánchez Martínez
Date:
Subject: Re: avoiding file system caching of a table