On Mon, Feb 17, 2014 at 7:30 PM, Gabriel Sánchez Martínez <
gabrielesanc...@gmail.com> wrote:
>
> On 02/17/2014 08:45 PM, Jeff Janes wrote:
>
> On Mon, Feb 17, 2014 at 5:09 PM, "Gabriel E. Sánchez Martínez" <
> gabrielesanc...@gmail.com> wrote:
>
>>
>>
>> I have read forum postings saying that t
On Mon, Feb 17, 2014 at 2:33 PM, Gabriel Sánchez Martínez <
gabrielesanc...@gmail.com> wrote:
> Is there a way of asking PostgreSQL to read the files of a table directly
> off the disk, asking the OS not to use the file cache? I am running
> PostgreSQL 9.1 on Ubuntu Server 64-bit. The server in
On 02/17/2014 08:45 PM, Jeff Janes wrote:
On Mon, Feb 17, 2014 at 5:09 PM, "Gabriel E. Sánchez Martínez"
mailto:gabrielesanc...@gmail.com>> wrote:
On 02/16/2014 10:33 PM, Gabriel Sánchez Martínez wrote:
Is there a way of asking PostgreSQL to read the files of a
table dire
Jeff Janes 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.
On Mon, Feb 17, 2014 at 5:09 PM, "Gabriel E. Sánchez Martínez" <
gabrielesanc...@gmail.com> wrote:
>
> On 02/16/2014 10:33 PM, Gabriel Sánchez Martínez wrote:
>
>> Is there a way of asking PostgreSQL to read the files of a table directly
>> off the disk, asking the OS not to use the file cache? I
On 02/16/2014 10:33 PM, Gabriel Sánchez Martínez wrote:
Is there a way of asking PostgreSQL to read the files of a table
directly off the disk, asking the OS not to use the file cache? I am
running PostgreSQL 9.1 on Ubuntu Server 64-bit. The server in
question has the maximum amount of RAM i
Is there a way of asking PostgreSQL to read the files of a table
directly off the disk, asking the OS not to use the file cache? I am
running PostgreSQL 9.1 on Ubuntu Server 64-bit. The server in question
has the maximum amount of RAM it supports, but the database has grown
much larger. Most