Re: [PERFORM] Postgres slave not catching up (on 9.2)

2014-12-15 Thread Ruben Domingo Gaspar Aparicio
> dbnasg403-12a:/vol/dodpupdbtst03 on /ORA/dbs03/PUPDBTST type nfs (rw, > actimeo=0,hard,nointr,rsize=65536,wsize=65536,tcp,timeo=600) > dbnasg401-12a:/vol/dodpupdbtst02 on /ORA/dbs02/PUPDBTST type nfs (rw, > actimeo=0,hard,nointr,rsize=65536,wsize=65536,tcp,timeo=600) > > to > > dbnasg403-12a:/v

Re: [PERFORM] Tuning the configuration

2014-12-15 Thread Graeme B. Bell
> Very much agree with this. Because SSD is fast doesn't make it suited for > certain things, and a streaming sequential 100% write workload is one of > them. I've worked with everything from local disk to high-end SAN and even > at the high end we've always put any DB logs on spinning disk.

Re: [PERFORM] Postgres slave not catching up (on 9.2)

2014-12-15 Thread Ruben Domingo Gaspar Aparicio
> > The slave (I don't have control on the master) is using 2 NFS file > > systems, one for WALs and another one for the data, on Netapp controllers: > > > > dbnasg401-12a:/vol/dodpupdbtst02 on /ORA/dbs02/PUPDBTST type nfs > > > (rw,remount,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,timeo=