On 2018-06-28 10:43:16 -0400, Rui DeSousa wrote: > > > > On Jun 28, 2018, at 9:47 AM, Vijaykumar Jain <vjain@xxxxxxxxxxxxx> wrote: > > > > Thanks Scott. > > > > fsync is on. > > > > postgres=# show fsync; > > fsync > > ------- > > on > > (1 row) > > > > Yeah, I agree with Scott; it sounds like fsync() is being shorted > somewhere in the I/O path. Are you using a RAID controller; if so is > the cache setting — write through or write back? If it’s write back > then writes are being cached and a power outage will lead to data > corruption — the only saving grace at that point would be the battery > backup logic on the controller which may or nay not be trustworthy. How are you making the inference that that's the problem? It could very well be a postgres bug or somebody having used pg_resetxlog or.. ? Greetings, Andres Freund
