Re: Old pg_xlog files

From: "Tass Chapman" <tasseh(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Old pg_xlog files
Date: 2006-03-23 13:10:54
Message-ID: ec9575e80603230510k2b36080fi4e10b9dbddbcdbe2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks.
I'll see if I can get a scheduled maintenance check on this.

The disks seem to be good as they are a 0+1 RAID and all internal tests
show them to be in good health along with the controller. Would memory be a
good suspect?

On 3/22/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Tass Chapman" <tasseh(dot)postgres(at)gmail(dot)com> writes:
> > Any suggestions on what I can look at to see why the checkpoint was so
> far
> > outstanding and why it hung on in a Zombie state when we tried a soft
> boot?
>
> If it was in a funny process state, I'd guess that there was some
> hardware problem that caused a disk write request to hang up. You
> can get stuck in uninterruptible disk wait for quite a long time if
> the disk doesn't respond.
>
> regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-03-23 13:25:52 Re: Logging of sql statements?
Previous Message Bjørn T Johansen 2006-03-23 13:07:11 Logging of sql statements?