[PERFORM] 1 machine + master DB with postgres_fdw + multiple DB instances on different ports

2014-06-16 Thread Gezeala M . Bacuño II
Does anybody have a similar setup: [a] 1 physical machine with half a terabyte of RAM, Xeon E7- 8837 @ 2.67GHz, huge ZFS pools + ZIL + L2ARC [b] master DB pg9.3 postgres_fdw with read/write capabilities, with tablespaces and WAL on separate zpools, archiving enabled (for zfs snapshots purposes),

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

2014-06-16 Thread Jeff Janes
On Thu, Jun 5, 2014 at 2:32 PM, Brio wrote: > 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. > ... > > I have noticed a few times that an ind