Re: [PERFORM] postgres files in use not staying in linux file cache

2014-06-24 Thread Brio
t it does, so I could try to recreate it? I'm not familiar with Perl, but I've done plenty of C programming, so demonstrating this with the actual Linux APIs would be ideal. Thanks Jeff! On Mon, Jun 23, 2014 at 3:56 PM, Jeff Janes wrote: > On Wed, Jun 18, 2014 at 11:18 PM, Brio wr

[PERFORM] postgres files in use not staying in linux file cache

2014-06-05 Thread Brio
Hi, I'm trying to investigate a performance problem. We have a large database (over 1TB) running on a server with 160GB of RAM and 32 cores (Xeon E5-2650). The database files are on a NetApp mount. The software is Postgres 9.3.1 on Ubuntu 12.04, Linux 3.2.0-38-generic. Generally, when a query is