Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgres 8.2.4 cores on SUN

postgres 8.2.4 cores on SUN

From
"Abraham, Danny"
Date:

Hi,

 

“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

  [3] XLogWrite(0x48, 0x6, 0x1, 0x1004883f8, 0x1000000, 0x10000192ca8), at 0x100078990

  [4] XLogFlush(0x7, 0x10000192cf0, 0x10048844c, 0x7, 0x1004a3524, 0x0), at 0x100079428

  [5] RecordTransactionCommit(0x0, 0xffffffff296f6120, 0x1004883d0, 0x0, 0x1004883d5, 0x0), at 0x1000713c0

  [6] CommitTransaction(0x1, 0x49fc00, 0x100488320, 0x488000, 0x100000000, 0x100000000), at 0x1000720a8

  [7] CommitTransactionCommand(0x1, 0x108, 0x4, 0x100488320, 0x0, 0x100072af8), at 0x100072c00

  [8] finish_xact_command(0x0, 0x28, 0x1, 0x4a0000, 0x100000000, 0x1004a00cc), at 0x100202adc

  [9] exec_simple_query(0x1005f7050, 0x1005f8b68, 0x2, 0x1006c42e8, 0x0, 0x1005f8b88), at 0x1002000fc

  [10] PostgresMain(0x0, 0x0, 0x1, 0x1, 0x1004a3400, 0x51), at 0x10020581c

  [11] BackendRun(0x4, 0x0, 0x35b800, 0x35b800, 0x10035b800, 0x0), at 0x1001cd0d8

  [12] BackendStartup(0x100540400, 0x100543150, 0x314c00, 0x1004a3400, 0x0, 0x100314e72), at 0x1001cc300

  [13] ServerLoop(0x100540400, 0x4, 0x6, 0x4a54c86f, 0xffff, 0x1004bd370), at 0x1001c943c

  [14] PostmasterMain(0x10049f400, 0x1cac00, 0x100507c00, 0x1, 0x1, 0x100000000), at 0x1001c8bc0

  [15] main(0x1, 0x1, 0x352c00, 0x0, 0x10051d4a0, 0x100507f50), at 0x10016faa4

 

Any idea?

 

Thanks

 

Danny

Re: postgres 8.2.4 cores on SUN

From
John R Pierce
Date:
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.