2007-03-31 15:36:26.266 PDT: 4946: DEBUG: postgres: PostmasterMain: initial environ dump: 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: ----------------------------------------- 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: SSH_AGENT_PID=3337 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: SHELL=/bin/bash 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: DESKTOP_STARTUP_ID= 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: TERM=xterm 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: GTK_RC_FILES=/etc/gtk/gtkrc:/home/jdavis/.gtkrc-1.2-gnome2 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: WINDOWID=44040665 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: USER=jdavis 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35: 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: SSH_AUTH_SOCK=/tmp/ssh-YjUqbL3294/agent.3294 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: GNOME_KEYRING_SOCKET=/tmp/keyring-mdkvPw/socket 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: USERNAME=jdavis 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: SESSION_MANAGER=local/jdavis:/tmp/.ICE-unix/3294 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: DESKTOP_SESSION=default 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: _=/home/jdavis/wd/pgsql/bin/postgres 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: GDM_XSERVER_LOCATION=local 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: PWD=/home/jdavis/wd 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LANG=en_US.UTF-8 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: PGSYSCONFDIR=/home/jdavis/wd/pgsql/etc 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: GDMSESSION=default 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: HISTCONTROL=ignoredups 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: SHLVL=2 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: HOME=/home/jdavis 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: GNOME_DESKTOP_SESSION_ID=Default 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LOGNAME=jdavis 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-CiSn5FNBHF,guid=cb5e904149038dde39d78800460ed65c 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: PGDATA=data 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LESSOPEN=| /usr/bin/lesspipe %s 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: DISPLAY=:0.0 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LESSCLOSE=/usr/bin/lesspipe %s %s 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: XAUTHORITY=/home/jdavis/.Xauthority 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: COLORTERM=gnome-terminal 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LC_COLLATE=en_US.UTF-8 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LC_CTYPE=en_US.UTF-8 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LC_MESSAGES=en_US.UTF-8 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LC_MONETARY=C 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LC_NUMERIC=C 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: LC_TIME=C 2007-03-31 15:36:26.266 PDT: 4946: DEBUG: ----------------------------------------- 2007-03-31 15:36:26.354 PDT: 4946: DEBUG: invoking IpcMemoryCreate(size=278994944) 2007-03-31 15:36:26.361 PDT: 4946: DEBUG: max_safe_fds = 985, usable_fds = 1000, already_open = 5 2007-03-31 15:36:26.362 PDT: 4947: LOG: database system was shut down at 2007-03-31 15:36:20 PDT 2007-03-31 15:36:26.362 PDT: 4947: LOG: checkpoint record is at 4/37EA8D98 2007-03-31 15:36:26.362 PDT: 4947: LOG: redo record is at 4/37EA8D98; undo record is at 0/0; shutdown TRUE 2007-03-31 15:36:26.362 PDT: 4947: LOG: next transaction ID: 0/957; next OID: 16387 2007-03-31 15:36:26.362 PDT: 4947: LOG: next MultiXactId: 1; next MultiXactOffset: 0 2007-03-31 15:36:26.441 PDT: 4947: LOG: database system is ready 2007-03-31 15:36:26.442 PDT: 4947: DEBUG: transaction ID wrap limit is 2147484171, limited by database "postgres" 2007-03-31 15:36:26.442 PDT: 4947: DEBUG: proc_exit(0) 2007-03-31 15:36:26.442 PDT: 4947: DEBUG: shmem_exit(0) 2007-03-31 15:36:26.442 PDT: 4947: DEBUG: exit(0) 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: postgres child[4962]: starting with ( 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: postgres 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: -v196608 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: -y 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: test 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: ) 2007-03-31 15:36:43.142 PDT: 4962: DEBUG: InitPostgres 2007-03-31 15:36:43.143 PDT: 4962: DEBUG: StartTransaction 2007-03-31 15:36:43.143 PDT: 4962: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 957/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.145 PDT: 4962: DEBUG: CommitTransaction 2007-03-31 15:36:43.145 PDT: 4962: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 957/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.146 PDT: 4946: DEBUG: forked new backend, pid=4962 socket=6 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: postgres child[4966]: starting with ( 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: postgres 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: -v196608 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: -y 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: test 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: ) 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: InitPostgres 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: StartTransaction 2007-03-31 15:36:43.147 PDT: 4966: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 958/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.148 PDT: 4966: DEBUG: CommitTransaction 2007-03-31 15:36:43.148 PDT: 4966: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 958/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.148 PDT: 4946: DEBUG: forked new backend, pid=4966 socket=6 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: postgres child[4967]: starting with ( 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: postgres 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: -v196608 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: -y 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: test 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: ) 2007-03-31 15:36:43.148 PDT: 4967: DEBUG: InitPostgres 2007-03-31 15:36:43.149 PDT: 4967: DEBUG: StartTransaction 2007-03-31 15:36:43.149 PDT: 4967: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 959/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.149 PDT: 4967: DEBUG: CommitTransaction 2007-03-31 15:36:43.149 PDT: 4967: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 959/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.149 PDT: 4946: DEBUG: forked new backend, pid=4967 socket=6 2007-03-31 15:36:43.150 PDT: 4946: DEBUG: forked new backend, pid=4968 socket=6 2007-03-31 15:36:43.150 PDT: 4962: DEBUG: StartTransactionCommand 2007-03-31 15:36:43.150 PDT: 4962: DEBUG: StartTransaction 2007-03-31 15:36:43.150 PDT: 4962: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 960/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: postgres child[4968]: starting with ( 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: postgres 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: -v196608 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: -y 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: test 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: ) 2007-03-31 15:36:43.150 PDT: 4968: DEBUG: InitPostgres 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: postgres child[4969]: starting with ( 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: postgres 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: -v196608 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: -y 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: test 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: ) 2007-03-31 15:36:43.150 PDT: 4969: DEBUG: InitPostgres 2007-03-31 15:36:43.151 PDT: 4968: DEBUG: StartTransaction 2007-03-31 15:36:43.151 PDT: 4968: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 961/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.151 PDT: 4969: DEBUG: StartTransaction 2007-03-31 15:36:43.151 PDT: 4969: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 962/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.151 PDT: 4968: DEBUG: CommitTransaction 2007-03-31 15:36:43.151 PDT: 4968: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 961/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.151 PDT: 4946: DEBUG: forked new backend, pid=4969 socket=6 2007-03-31 15:36:43.151 PDT: 4969: DEBUG: CommitTransaction 2007-03-31 15:36:43.151 PDT: 4969: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 962/1/0, nestlvl: 1, children: <> 2007-03-31 15:36:43.218 PDT: 4962: DEBUG: PortalRun 2007-03-31 15:37:13.151 PDT: 4966: DEBUG: StartTransactionCommand 2007-03-31 15:37:13.214 PDT: 4966: DEBUG: StartTransaction 2007-03-31 15:37:13.214 PDT: 4966: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 963/1/0, nestlvl: 1, children: <> 2007-03-31 15:37:13.822 PDT: 4966: DEBUG: PortalRun 2007-03-31 15:37:43.154 PDT: 4967: DEBUG: StartTransactionCommand 2007-03-31 15:37:43.154 PDT: 4967: DEBUG: StartTransaction 2007-03-31 15:37:43.154 PDT: 4967: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 964/1/0, nestlvl: 1, children: <> 2007-03-31 15:37:43.917 PDT: 4967: DEBUG: PortalRun 2007-03-31 15:38:13.158 PDT: 4968: DEBUG: StartTransactionCommand 2007-03-31 15:38:13.254 PDT: 4968: DEBUG: StartTransaction 2007-03-31 15:38:13.254 PDT: 4968: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 965/1/0, nestlvl: 1, children: <> 2007-03-31 15:38:13.920 PDT: 4968: DEBUG: PortalRun 2007-03-31 15:38:43.161 PDT: 4969: DEBUG: StartTransactionCommand 2007-03-31 15:38:43.161 PDT: 4969: DEBUG: StartTransaction 2007-03-31 15:38:43.161 PDT: 4969: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 966/1/0, nestlvl: 1, children: <> 2007-03-31 15:38:44.124 PDT: 4969: DEBUG: PortalRun 2007-03-31 15:48:58.158 PDT: 4962: LOG: EXECUTOR STATISTICS 2007-03-31 15:48:58.158 PDT: 4962: DETAIL: ! system usage stats: ! 734.939412 elapsed 28.693793 user 11.092693 system sec ! [28.697793 user 11.092693 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 1/66753 [2/67642] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 77929/7977 [77952/7983] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 1351352 read, 0 written, buffer hit rate = 0.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:48:59.042 PDT: 4962: DEBUG: CommitTransactionCommand 2007-03-31 15:48:59.042 PDT: 4962: DEBUG: CommitTransaction 2007-03-31 15:48:59.042 PDT: 4962: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 960/1/0, nestlvl: 1, children: <> 2007-03-31 15:48:59.042 PDT: 4962: LOG: duration: 735892.271 ms statement: --SET sync_seqscan_threshold=-1; --SET sync_seqscan_offset=0; --SET trace_sync_seqscan=true; SELECT COUNT(*) FROM test; 2007-03-31 15:48:59.380 PDT: 4962: DEBUG: proc_exit(0) 2007-03-31 15:48:59.380 PDT: 4962: DEBUG: shmem_exit(0) 2007-03-31 15:48:59.380 PDT: 4962: DEBUG: exit(0) 2007-03-31 15:48:59.396 PDT: 4946: DEBUG: server process (PID 4962) exited with exit code 0 2007-03-31 15:50:11.884 PDT: 4966: LOG: EXECUTOR STATISTICS 2007-03-31 15:50:11.884 PDT: 4966: DETAIL: ! system usage stats: ! 778.062065 elapsed 29.413838 user 10.612663 system sec ! [29.413838 user 10.612663 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 1/66812 [1/67620] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 82515/9001 [82548/9004] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 1351352 read, 0 written, buffer hit rate = 0.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:50:12.456 PDT: 4966: DEBUG: CommitTransactionCommand 2007-03-31 15:50:12.456 PDT: 4966: DEBUG: CommitTransaction 2007-03-31 15:50:12.456 PDT: 4966: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 963/1/0, nestlvl: 1, children: <> 2007-03-31 15:50:12.456 PDT: 4966: LOG: duration: 779305.559 ms statement: --SET sync_seqscan_threshold=-1; --SET sync_seqscan_offset=0; --SET trace_sync_seqscan=true; SELECT COUNT(*) FROM test; 2007-03-31 15:50:12.731 PDT: 4966: DEBUG: proc_exit(0) 2007-03-31 15:50:12.731 PDT: 4966: DEBUG: shmem_exit(0) 2007-03-31 15:50:12.731 PDT: 4966: DEBUG: exit(0) 2007-03-31 15:50:12.742 PDT: 4946: DEBUG: server process (PID 4966) exited with exit code 0 2007-03-31 15:50:43.570 PDT: 4967: LOG: EXECUTOR STATISTICS 2007-03-31 15:50:43.570 PDT: 4967: DETAIL: ! system usage stats: ! 779.653129 elapsed 29.065816 user 10.980686 system sec ! [29.065816 user 10.980686 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 1/66800 [1/67620] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 82501/8946 [82530/8948] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 1351352 read, 0 written, buffer hit rate = 0.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:50:43.572 PDT: 4967: DEBUG: CommitTransactionCommand 2007-03-31 15:50:43.572 PDT: 4967: DEBUG: CommitTransaction 2007-03-31 15:50:43.572 PDT: 4967: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 964/1/0, nestlvl: 1, children: <> 2007-03-31 15:50:43.572 PDT: 4967: LOG: duration: 780418.307 ms statement: --SET sync_seqscan_threshold=-1; --SET sync_seqscan_offset=0; --SET trace_sync_seqscan=true; SELECT COUNT(*) FROM test; 2007-03-31 15:50:43.884 PDT: 4967: DEBUG: proc_exit(0) 2007-03-31 15:50:43.884 PDT: 4967: DEBUG: shmem_exit(0) 2007-03-31 15:50:43.884 PDT: 4967: DEBUG: exit(0) 2007-03-31 15:50:43.895 PDT: 4946: DEBUG: server process (PID 4967) exited with exit code 0 2007-03-31 15:51:38.879 PDT: 4968: LOG: EXECUTOR STATISTICS 2007-03-31 15:51:38.879 PDT: 4968: DETAIL: ! system usage stats: ! 804.958629 elapsed 29.253828 user 10.648665 system sec ! [29.257828 user 10.652665 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 1/66800 [1/67618] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 82514/8914 [82544/8915] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 1351352 read, 0 written, buffer hit rate = 0.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:51:38.881 PDT: 4968: DEBUG: CommitTransactionCommand 2007-03-31 15:51:38.881 PDT: 4968: DEBUG: CommitTransaction 2007-03-31 15:51:38.881 PDT: 4968: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 965/1/0, nestlvl: 1, children: <> 2007-03-31 15:51:38.881 PDT: 4968: LOG: duration: 805723.114 ms statement: --SET sync_seqscan_threshold=-1; --SET sync_seqscan_offset=0; --SET trace_sync_seqscan=true; SELECT COUNT(*) FROM test; 2007-03-31 15:51:39.068 PDT: 4968: DEBUG: proc_exit(0) 2007-03-31 15:51:39.068 PDT: 4968: DEBUG: shmem_exit(0) 2007-03-31 15:51:39.068 PDT: 4968: DEBUG: exit(0) 2007-03-31 15:51:39.079 PDT: 4946: DEBUG: server process (PID 4968) exited with exit code 0 2007-03-31 15:51:56.948 PDT: 4969: LOG: EXECUTOR STATISTICS 2007-03-31 15:51:56.948 PDT: 4969: DETAIL: ! system usage stats: ! 792.824631 elapsed 28.869804 user 11.212700 system sec ! [28.869804 user 11.212700 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 0/66798 [0/67618] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 80826/8614 [80855/8617] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 1351352 read, 0 written, buffer hit rate = 0.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:51:56.948 PDT: 4969: DEBUG: CommitTransactionCommand 2007-03-31 15:51:56.948 PDT: 4969: DEBUG: CommitTransaction 2007-03-31 15:51:56.948 PDT: 4969: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 966/1/0, nestlvl: 1, children: <> 2007-03-31 15:51:56.948 PDT: 4969: LOG: duration: 793787.932 ms statement: --SET sync_seqscan_threshold=-1; --SET sync_seqscan_offset=0; --SET trace_sync_seqscan=true; SELECT COUNT(*) FROM test; 2007-03-31 15:51:56.949 PDT: 4969: DEBUG: proc_exit(0) 2007-03-31 15:51:56.949 PDT: 4969: DEBUG: shmem_exit(0) 2007-03-31 15:51:56.949 PDT: 4969: DEBUG: exit(0) 2007-03-31 15:51:56.960 PDT: 4946: DEBUG: server process (PID 4969) exited with exit code 0 2007-03-31 16:04:09.369 PDT: 4946: DEBUG: postmaster received signal 15 2007-03-31 16:04:09.369 PDT: 4946: LOG: received smart shutdown request 2007-03-31 16:04:09.370 PDT: 4948: LOG: shutting down 2007-03-31 16:04:09.694 PDT: 4948: LOG: database system is shut down 2007-03-31 16:04:09.698 PDT: 4948: DEBUG: proc_exit(0) 2007-03-31 16:04:09.698 PDT: 4948: DEBUG: shmem_exit(0) 2007-03-31 16:04:09.698 PDT: 4948: DEBUG: exit(0) 2007-03-31 16:04:09.698 PDT: 4946: DEBUG: proc_exit(0) 2007-03-31 16:04:09.698 PDT: 4946: DEBUG: shmem_exit(0) 2007-03-31 16:04:09.765 PDT: 4946: DEBUG: exit(0)