> > > > But we do don't we? fsync = off, full_page_writes = off?
> > 
> > BTW, our testing seems to indicate that full_page_writes = off is
> > on Solaris 10 on good hardware.  At least, we haven't been able to
break it yet.
> > 
> Is that an OS-dependent parameter? I always assumed it depended
> on hardware. I have no way to test it for myself though, so I just
> full_page_writes=on to be safe.

It also depends on the FS implementation. The OS/FS must guarantee, that
it does not chunk single data page write calls. Usually that is the
case, when OS/FS pagesize and pg pagesize are identical. And the HW
needs to guarantee atomicity for single calls. e.g. on AIX you need to
reduce the pg page size to 4k to be able to give those guarantees.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to