Re: A stupid question :) - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: A stupid question :)
Date
Msg-id 39EF7661.52F25251@selectacast.net
Whole thread Raw
In response to A stupid question :)  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
DaVinci wrote:
>
> Excuse my ignorance but I have browsed TODO list and haven't found
> anything...
>
> What is WAL?
>
> Greets.
>
>                                                 David

Write Ahead Logging.

i.e. Whenever you do an UPDATE to postgres it is garunteed to be in the
log, and therefore you can use the log to rebuild the database because
*everything* is in the long.

Unless you do domething like SET timefield = CURRENT_TIMESTAMP or
something.

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com

pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Re: Any risk in increasing BLCKSZ to get larger tuples?
Next
From: "David Reid"
Date:
Subject: Re: MySQL -> pgsql