Re: [GENERAL] Running PostgreSQL with ZFS ZIL

2015-07-02 Thread Joseph Kregloh
On Thu, Jul 2, 2015 at 11:50 AM, Vick Khera wrote: > > On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh > wrote: > >> With my dataset I have been able to take advantage of the L2ARC. >> Currently using about 80GB on ARC and 260GB on L2ARC. With the ARC >> currently having the greater Hit ratio. >

Re: [GENERAL] Running PostgreSQL with ZFS ZIL

2015-07-02 Thread Vick Khera
On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh wrote: > With my dataset I have been able to take advantage of the L2ARC. Currently > using about 80GB on ARC and 260GB on L2ARC. With the ARC currently having > the greater Hit ratio. > Did you tell postgres that the effective_cache_size = Shared

Re: [GENERAL] Running PostgreSQL with ZFS ZIL

2015-07-02 Thread Joseph Kregloh
On Thu, Jul 2, 2015 at 9:35 AM, Vick Khera wrote: > > On Wed, Jul 1, 2015 at 5:07 PM, Joseph Kregloh > wrote: > >> We recently built a new server for our Production database. The machine >> is top of the line with 128GB of RAM, dual E5-2650. We also included NVME >> drives for ZIL and L2ARC. Cur

Re: [GENERAL] Running PostgreSQL with ZFS ZIL

2015-07-02 Thread Vick Khera
On Wed, Jul 1, 2015 at 5:07 PM, Joseph Kregloh wrote: > We recently built a new server for our Production database. The machine is > top of the line with 128GB of RAM, dual E5-2650. We also included NVME > drives for ZIL and L2ARC. Currently we have 3 zpools. First one holds the > FreeBSD install

[GENERAL] Running PostgreSQL with ZFS ZIL

2015-07-01 Thread Joseph Kregloh
We recently built a new server for our Production database. The machine is top of the line with 128GB of RAM, dual E5-2650. We also included NVME drives for ZIL and L2ARC. Currently we have 3 zpools. First one holds the FreeBSD install. Second holds the jails, and third holds all of the database da