/var/lib/pgsql/data/pg_xlog/000000010000000000000000,two process access it ?
От | Thomas |
---|---|
Тема | /var/lib/pgsql/data/pg_xlog/000000010000000000000000,two process access it ? |
Дата | |
Msg-id | 0c261a12-1d93-4441-82e5-99a78069845f@x25g2000prf.googlegroups.com обсуждение исходный текст |
Список | 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@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
В списке pgsql-general по дате отправления: