Обсуждение: postgres 8.2.4 cores on SUN

Поиск
Список
Период
Сортировка

postgres 8.2.4 cores on SUN

От
"Abraham, Danny"
Дата:

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

От
John R Pierce
Дата:
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.