Search Postgresql Archives

/var/lib/pgsql/data/pg_xlog/000000010000000000000000,two process access it ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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@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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux