With that said, I assume my current version of pgsql DOES make all this heavy work go through WAL logging.
Curious thing is that I remember (of course) reviewing logs of the crash times, and I didn't see anything strange, not even the famous warning "you are making checkpoints too often. maybe you should consider using extending the checkpoint_segments parameter". I will check it again. Besides, I will try to gather as much information on the system itself (RAID controllers, disk vendors, etc). Thank you, will keep you posted. On Wed, Jan 13, 2010 at 11:06 AM, Euler Taveira de Oliveira < eu...@timbira.com> wrote: > Eduardo Piombino escreveu: > > Maybe it does not get logged at all until the ALTER is completed? > > > This feature [1] was implemented a few months ago and it will be available > only in the next PostgreSQL version (8.5). > > [1] http://archives.postgresql.org/pgsql-committers/2009-11/msg00018.php > > > -- > Euler Taveira de Oliveira > http://www.timbira.com/ >
