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
