Re: improving write performance for logging - Mailing list pgsql-performance

From Tom Lane
Subject Re: improving write performance for logging
Date
Msg-id 22489.1136579266@sss.pgh.pa.us
Whole thread Raw
In response to Re: improving write performance for logging  (Ian Westmacott <ianw@intellivid.com>)
List pgsql-performance
Ian Westmacott <ianw@intellivid.com> writes:
> If the WAL is lost, can you lose more than the data since the last
> checkpoint?

The problem is that you might have partially-applied actions since the
last checkpoint, rendering your database inconsistent; then *all* the
data is suspect if not actually corrupt.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow query. Any way to speed up?
Next
From: peter royal
Date:
Subject: help tuning queries on large database