Re: postgres 8.2.4 cores on SUN

From: John R Pierce <pierce(at)hogranch(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres 8.2.4 cores on SUN
Date: 2009-12-17 18:42:18
Message-ID: 4B2A7B8A.4040006@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Abraham, Danny wrote:
>
> “postgres” cores on SUN 2.9. Disk is in 100% IO.
>
> (dbx) where
>
> [1] 0xffffffff65eacdd4(0xffffffff7fffa36c, 0x400, 0x10032d4e8, 0x1,
> 0x48, 0xd6), at 0xffffffff65eacdd4
>
> [2] XLogFileInit(0x48, 0xd6, 0xffffffff7fffa85d, 0x1, 0x488000, 0x0),
> at 0x10007955c
>
> ...
>
> Any idea?
>

now without a lot more input.

where did this postgres 8.2.4 come from, how is it configured, what
hardware is it running on, what operation(s) are you doing when it
'cores', what is the disk doing thats 10)% busy (eg, what file(s), etc)
was this system stable prior to this happening, etc etc etc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2009-12-17 19:29:27 Re: How to remove non-UTF values from a table?
Previous Message Tom Lane 2009-12-17 18:40:10 Re: Trigger function language