Indeed I could save some IO with noatime. I must say I haven’t found any
recommendation about mount options for postgresql, likely because this is not
encourage. The ones you see are taking from a Oracle cluster configuration
where several nodes see the same files. It's not the case on this setu
Hi Andres,
Sorry for my delay to reply. Here below my replies:
> I have a couple of questions:
> 1) Is the standby actually used for querying? Is it possible that replay
>frequently conflicts with active queries? As you don't have
>hot_standby_feedback enabled that seems quite possible.
> > 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=
> 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
