Re: Postgresql logging questions

On 01/30/12 12:14 PM, Heine Ferreira wrote:
>
> Most RDBMS's log all sql changes.
> When the server crashes or a power failure occurs and the server comes
> back up
> the rdbms rolls back to the nearest checkpoint and does a roll forward
> from the log.
>
> Does Postgres also do this?
>

yes, although it uses a somewhat different technique than you describe.

>
> If so is Postgres logging any beter than other databases?

'better' is subjective without defined metrics.

> How good is Postgres at surviving power failures?
> This is of course assuming that you don't have a ups.

UPS's fail too :)

assuming your file system and storage hardware are robust and doesn't do
things like lie about write caching, postgres is very good about
recovery to the last committed transaction.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast