From: | Thomas <freebsdjlu(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | /var/lib/pgsql/data/pg_xlog/000000010000000000000000,two process access it ? |
Date: | 2009-12-24 10:20:41 |
Message-ID: | 0c261a12-1d93-4441-82e5-99a78069845f@x25g2000prf.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I guess PID 19045 write data to the log file first when I insert data
into table ,but why did writer process also access the log file ?
Could some guy tell me some details ?
FYI:
postgres: writer process's PID is 18848 .
postgres test [local] idle's PID is 19045 .
[root(at)localhost tmp]# lsof /var/lib/pgsql/data/pg_xlog/
000000010000000000000000
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
postmaste 18848 postgres 4u REG 253,0 16777216 1770912 /var/lib/
pgsql/data/pg_xlog/000000010000000000000000
postmaste 19045 postgres 37u REG 253,0 16777216 1770912 /var/lib/
pgsql/data/pg_xlog/000000010000000000000000
[root(at)localhost tmp]# ps aux|grep postgre
postgres 2429 0.0 0.6 21044 3364 ? S 07:32 0:00 /usr/
bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 2434 0.0 0.1 10824 804 ? S 07:32 0:00
postgres: logger process
root 9539 0.0 0.2 4908 1232 pts/3 S 15:31 0:00 su -
postgres
postgres 9540 0.0 0.2 4528 1480 pts/3 S 15:31 0:00 -bash
postgres 18848 0.0 0.2 21180 1324 ? S 17:23 0:00
postgres: writer process
postgres 18849 0.0 0.1 11824 780 ? S 17:23 0:00
postgres: stats buffer process
postgres 18850 0.0 0.1 11056 1000 ? S 17:23 0:00
postgres: stats collector process
postgres 19029 0.0 0.4 8292 2296 pts/3 S+ 17:25 0:00 psql
postgres 19045 0.0 0.7 21888 4016 ? S 17:25 0:00
postgres: postgres test [local] idle
root 19607 0.0 0.1 3912 696 pts/2 R+ 17:31 0:00 grep
postgre
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas | 2009-12-24 10:24:28 | Re: postgres: writer process,what does this process actually do? |
Previous Message | Alban Hertroys | 2009-12-24 10:10:57 | Re: WARNING: nonstandard use of escape in a string literal |