rt_sigprocmask

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: rt_sigprocmask
Date: 2003-10-10 18:44:04
Message-ID: 3F86FDF4.3070307@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,
I'm importing on Postgres 7.3.4 a dump and after one hour
the process is still there to perform a COPY of a table with about
~1.5M rows.

I did an strace on it and I had a lot of rt_sigprocmask
comparing to read and write operations.
What is going on?

# strace -p 6370

read(33, "\n\0\0\0|-l\3146\0\0\0\254\1\270\1\0 \1 \264\237\230\0"...,
8192) = 8192
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
_llseek(22, 0, [3268608], SEEK_END) = 0
write(22, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
8192) = 8192
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
_llseek(21, 0, [3358720], SEEK_END) = 0
write(21, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
8192) = 8192
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0

( here the Load average is 25% because the box have 4 processors )
# iostat 1
Linux 2.4.20-13.9smp (dell-01) 10/10/2003

avg-cpu: %user %nice %sys %idle
6.98 0.02 2.26 90.74

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 11.39 167.16 151.52 493154000 447007536

avg-cpu: %user %nice %sys %idle
27.00 0.00 1.25 71.75

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 0.00 0.00 0.00 0 0

avg-cpu: %user %nice %sys %idle
27.75 0.00 0.75 71.50

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 0.00 0.00 0.00 0 0

avg-cpu: %user %nice %sys %idle
25.50 0.00 1.75 72.75

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 0.00 0.00 0.00 0 0

avg-cpu: %user %nice %sys %idle
26.25 0.00 6.25 67.50

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 10.00 0.00 200.00 0 200

# vmstat 1
procs memory swap io system
cpu
r b w swpd free buff cache si so bi bo in cs
us sy id
1 0 0 407940 21588 125596 470968 1 1 3 1 0 0
0 2 0
1 0 0 407940 21588 125596 470968 0 0 0 0 531 480
30 1 69
1 0 0 407940 21588 125624 470964 0 0 0 116 549 494
26 6 68
1 0 0 407940 21588 125624 470964 0 0 0 0 582 499
29 1 70
1 0 0 407940 21588 125624 470964 0 0 0 0 561 517
29 1 69
1 0 0 407940 21588 125624 470964 0 0 0 0 531 537
27 1 71
1 0 0 407940 21588 125624 470964 0 0 0 0 542 470
26 1 73
1 0 0 407940 21584 125636 470964 0 0 0 52 553 493
23 7 71
1 0 0 407940 21584 125636 470972 0 0 0 0 548 491
23 9 68
1 0 0 407940 21584 125636 470972 0 0 0 0 542 498
10 19 71
1 0 0 407940 21584 125636 470972 0 0 0 0 547 472
22 8 70
1 0 0 407940 21584 125636 470972 0 0 0 0 576 512
29 2 69
1 0 0 407940 21584 125640 470968 0 0 0 56 564 510
30 2 68
2 0 0 407940 21584 125640 470976 0 0 0 0 524 509
29 2 69
1 0 0 407940 21584 125640 470976 4 0 4 0 630 634
30 1 69

Regards
Gaetano Mendola

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2003-10-10 19:02:55 Re: 2-phase commit
Previous Message Bruce Momjian 2003-10-10 18:34:01 Re: compile warning