FW: postgres 8.2.4 cores on SUN - Mailing list pgsql-general

From Abraham, Danny
Subject FW: postgres 8.2.4 cores on SUN
Date
Msg-id 2C0926ABD16BB641A8E2F11A5492004214232DA9EB@PHXCCRPRD01.adprod.bmc.com
Whole thread Raw
List pgsql-general

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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: flagging first row inserted for each "group" of key
Next
From: "Abraham, Danny"
Date:
Subject: postgres 8.2.4 cores on SUN