From: Eduardo Piombino <drakorg@gmail.com>
To: Euler Taveira de Oliveira <euler@timbira.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: a heavy duty operation on an "unused" table kills my server
Date: Wed, 13 Jan 2010 12:53:59 -0300
Message-ID: <e24c1d9d1001130753g3a184d72jfed374ae63349a4@mail.gmail.com> (raw)
In-Reply-To: <4B4DD381.6070302@timbira.com>
References: <e24c1d9d1001122059ic5d4721o98ccf85033b1fead@mail.gmail.com>
<4B4D5698.8040808@emolecules.com>
<e24c1d9d1001122147l1c0e2111kce25dc2c7f393087@mail.gmail.com>
<4B4D78B2.30600@2ndquadrant.com>
<e24c1d9d1001130027u463daa4cy2f687e1d27556b79@mail.gmail.com>
<4B4DD381.6070302@timbira.com>
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 <
euler@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/
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: drakorg@gmail.com, euler@timbira.com, greg@2ndquadrant.com, craig_james@emolecules.com
Subject: Re: a heavy duty operation on an "unused" table kills my server
In-Reply-To: <e24c1d9d1001130753g3a184d72jfed374ae63349a4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox