94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: postgres: PostmasterMain: initial environ dump: 94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: ----------------------------------------- 94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: MACHTYPE=i386 94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: USER=pgsql 94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: MAIL=/var/mail/pgsql 94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: VENDOR=intel 94825: 2007-03-29 16:50:00.951 PDT <> DEBUG: SHLVL=2 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: OLDPWD=/usr/local/pgsql/wd/install 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: HOME=/usr/local/pgsql 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: GROUP=pgsql 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LOGNAME=pgsql 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: _=/usr/local/bin/pg_ctl 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: BLOCKSIZE=K 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: TERM=xterm 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: PGSYSCONFDIR=/usr/local/etc/postgresql 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: PGLOCALEDIR=/usr/local/share/locale 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/pgsql/bin 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: SHELL=/bin/tcsh 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: OSTYPE=FreeBSD 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: PWD=/usr/local/pgsql/wd 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: PGDATA=/usr/local/pgsql/data 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: FTP_PASSIVE_MODE=YES 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: HOSTTYPE=FreeBSD 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LC_COLLATE=C 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LC_CTYPE=C 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LC_MESSAGES=en_US.UTF-8 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LC_MONETARY=C 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LC_NUMERIC=C 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: LC_TIME=C 94825: 2007-03-29 16:50:00.952 PDT <> DEBUG: ----------------------------------------- 94825: 2007-03-29 16:50:01.153 PDT <> LOG: could not load root certificate file "root.crt": No such file or directory 94825: 2007-03-29 16:50:01.153 PDT <> DETAIL: Will not verify client certificates. 94825: 2007-03-29 16:50:01.161 PDT <> DEBUG: invoking IpcMemoryCreate(size=1135034368) 94825: 2007-03-29 16:50:01.253 PDT <> DEBUG: max_safe_fds = 4984, usable_fds = 5000, already_open = 6 94826: 2007-03-29 16:50:01.264 PDT <> LOG: database system was shut down at 2007-03-29 16:48:51 PDT 94826: 2007-03-29 16:50:01.270 PDT <> LOG: checkpoint record is at 81/826956D0 94826: 2007-03-29 16:50:01.270 PDT <> LOG: redo record is at 81/826956D0; undo record is at 0/0; shutdown TRUE 94826: 2007-03-29 16:50:01.270 PDT <> LOG: next transaction ID: 0/16997048; next OID: 48261 94826: 2007-03-29 16:50:01.270 PDT <> LOG: next MultiXactId: 1; next MultiXactOffset: 0 94826: 2007-03-29 16:50:01.273 PDT <> LOG: database system is ready 94826: 2007-03-29 16:50:01.299 PDT <> DEBUG: transaction ID wrap limit is 2147484171, limited by database "postgres" 94826: 2007-03-29 16:50:01.307 PDT <> DEBUG: proc_exit(0) 94826: 2007-03-29 16:50:01.307 PDT <> DEBUG: shmem_exit(0) 94826: 2007-03-29 16:50:01.307 PDT <> DEBUG: exit(0) 94829: 2007-03-29 16:50:01.312 PDT <> DEBUG: StartTransaction 94829: 2007-03-29 16:50:01.312 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997048/1/0, nestlvl: 1, children: <> 94829: 2007-03-29 16:50:01.349 PDT <> DEBUG: CommitTransaction 94829: 2007-03-29 16:50:01.349 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997048/1/0, nestlvl: 1, children: <> 94829: 2007-03-29 16:50:01.349 PDT <> DEBUG: autovacuum: processing database "pgsql" 94829: 2007-03-29 16:50:01.349 PDT <> DEBUG: StartTransaction 94829: 2007-03-29 16:50:01.349 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997049/1/0, nestlvl: 1, children: <> 94829: 2007-03-29 16:50:01.353 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94829: 2007-03-29 16:50:01.353 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94829: 2007-03-29 16:50:01.353 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94829: 2007-03-29 16:50:01.353 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94829: 2007-03-29 16:50:01.353 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_statistic: vac: 302 (threshold 560), anl: 302 (threshold 280) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_type: vac: 0 (threshold 549), anl: 0 (threshold 274) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 827), anl: 0 (threshold 414) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 270) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: CommitTransaction 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997049/1/0, nestlvl: 1, children: <> 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: proc_exit(0) 94829: 2007-03-29 16:50:01.354 PDT <> DEBUG: shmem_exit(0) 94829: 2007-03-29 16:50:01.355 PDT <> DEBUG: exit(0) 94825: 2007-03-29 16:50:03.934 PDT <> DEBUG: forked new backend, pid=94831 socket=7 94831: 2007-03-29 16:50:03.934 PDT DEBUG: postgres child[94831]: starting with ( 94831: 2007-03-29 16:50:03.934 PDT DEBUG: postgres 94831: 2007-03-29 16:50:03.934 PDT DEBUG: -v196608 94831: 2007-03-29 16:50:03.934 PDT DEBUG: -y 94831: 2007-03-29 16:50:03.934 PDT DEBUG: db02 94831: 2007-03-29 16:50:03.934 PDT DEBUG: ) 94831: 2007-03-29 16:50:03.935 PDT DEBUG: InitPostgres 94831: 2007-03-29 16:50:03.935 PDT DEBUG: StartTransaction 94831: 2007-03-29 16:50:03.935 PDT DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997050/1/0, nestlvl: 1, children: <> 94831: 2007-03-29 16:50:03.954 PDT DEBUG: CommitTransaction 94831: 2007-03-29 16:50:03.955 PDT DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997050/1/0, nestlvl: 1, children: <> 94831: 2007-03-29 16:50:07.080 PDT DEBUG: StartTransactionCommand 94831: 2007-03-29 16:50:07.080 PDT DEBUG: StartTransaction 94831: 2007-03-29 16:50:07.080 PDT DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997051/1/0, nestlvl: 1, children: <> 94831: 2007-03-29 16:50:07.119 PDT DEBUG: PortalRun 94825: 2007-03-29 16:50:26.669 PDT <> DEBUG: forked new backend, pid=94832 socket=7 94832: 2007-03-29 16:50:26.669 PDT <[unknown]> LOG: incomplete startup packet 94832: 2007-03-29 16:50:26.669 PDT <[unknown]> DEBUG: proc_exit(0) 94832: 2007-03-29 16:50:26.669 PDT <[unknown]> DEBUG: shmem_exit(0) 94832: 2007-03-29 16:50:26.669 PDT <[unknown]> DEBUG: exit(0) 94825: 2007-03-29 16:50:26.670 PDT <> DEBUG: server process (PID 94832) exited with exit code 0 94833: 2007-03-29 16:51:26.694 PDT <> DEBUG: StartTransaction 94833: 2007-03-29 16:51:26.700 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997052/1/0, nestlvl: 1, children: <> 94833: 2007-03-29 16:51:26.782 PDT <> DEBUG: CommitTransaction 94833: 2007-03-29 16:51:26.782 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997052/1/0, nestlvl: 1, children: <> 94833: 2007-03-29 16:51:26.786 PDT <> DEBUG: autovacuum: processing database "template1" 94833: 2007-03-29 16:51:26.786 PDT <> DEBUG: StartTransaction 94833: 2007-03-29 16:51:26.786 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997053/1/0, nestlvl: 1, children: <> 94833: 2007-03-29 16:51:26.788 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94833: 2007-03-29 16:51:26.788 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94833: 2007-03-29 16:51:26.788 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94833: 2007-03-29 16:51:26.788 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94833: 2007-03-29 16:51:26.788 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_statistic: vac: 302 (threshold 560), anl: 302 (threshold 280) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_type: vac: 0 (threshold 548), anl: 0 (threshold 274) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 826), anl: 0 (threshold 413) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 270) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94833: 2007-03-29 16:51:26.789 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: pg_auth_members: vac: 0 (threshold 500), anl: 0 (threshold 250) 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: CommitTransaction 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997053/1/0, nestlvl: 1, children: <> 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: proc_exit(0) 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: shmem_exit(0) 94833: 2007-03-29 16:51:26.790 PDT <> DEBUG: exit(0) 94834: 2007-03-29 16:52:26.834 PDT <> DEBUG: StartTransaction 94834: 2007-03-29 16:52:26.849 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997054/1/0, nestlvl: 1, children: <> 94834: 2007-03-29 16:52:26.884 PDT <> DEBUG: CommitTransaction 94834: 2007-03-29 16:52:26.884 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997054/1/0, nestlvl: 1, children: <> 94834: 2007-03-29 16:52:26.884 PDT <> DEBUG: autovacuum: processing database "db02" 94834: 2007-03-29 16:52:26.884 PDT <> DEBUG: StartTransaction 94834: 2007-03-29 16:52:26.884 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997055/1/0, nestlvl: 1, children: <> 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: pg_toast_1255: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: pg_toast_2619: vac: 5 (threshold 511), anl: 6 (threshold 255) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.928 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.929 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_statistic: vac: 554 (threshold 623), anl: 554 (threshold 311) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_type: vac: 0 (threshold 589), anl: 0 (threshold 294) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 1264), anl: 0 (threshold 632) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_proc: vac: 0 (threshold 966), anl: 0 (threshold 483) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_class: vac: 0 (threshold 608), anl: 0 (threshold 304) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_attrdef: vac: 0 (threshold 514), anl: 0 (threshold 257) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 532), anl: 0 (threshold 266) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 503), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: tt1: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: tt2: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_toast_46612: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: entity_attr: vac: 0 (threshold 1963), anl: 156 (threshold 981) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_index: vac: 0 (threshold 546), anl: 0 (threshold 273) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_operator: vac: 0 (threshold 649), anl: 0 (threshold 324) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 522), anl: 0 (threshold 261) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_amop: vac: 0 (threshold 599), anl: 0 (threshold 299) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 552), anl: 0 (threshold 276) 94834: 2007-03-29 16:52:26.934 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_largeobject: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 262) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 518), anl: 0 (threshold 259) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 531), anl: 0 (threshold 265) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_listener: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_description: vac: 0 (threshold 896), anl: 0 (threshold 448) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_cast: vac: 0 (threshold 552), anl: 0 (threshold 276) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 506), anl: 0 (threshold 253) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1899), anl: 0 (threshold 950) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_auth_members: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: ttime: vac: 0 (threshold 503), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: slony_test: vac: 0 (threshold 100502), anl: 0 (threshold 50251) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: t10: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity_category: vac: 0 (threshold 503), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: empty: vac: 0 (threshold 1626), anl: 0 (threshold 813) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: t145: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: ti1: vac: 0 (threshold 200500), anl: 0 (threshold 100250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: ti2: vac: 0 (threshold 200500), anl: 0 (threshold 100250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity_relation: vac: 50 (threshold 3478), anl: 53 (threshold 1739) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: a: vac: 0 (threshold 2000500), anl: 0 (threshold 1000250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: b: vac: 0 (threshold 2000500), anl: 0 (threshold 1000250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity_relation_member: vac: 0 (threshold 2100), anl: 50 (threshold 1050) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: meta: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity: vac: 0 (threshold 516), anl: 0 (threshold 258) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_toast_17040: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity_attr: vac: 0 (threshold 547), anl: 0 (threshold 274) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: tmp2: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity_category: vac: 0 (threshold 504), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: entity_relation: vac: 0 (threshold 539), anl: 0 (threshold 270) 94834: 2007-03-29 16:52:26.935 PDT <> DEBUG: pg_ts_cfg: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_ts_cfgmap: vac: 0 (threshold 519), anl: 0 (threshold 260) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_ts_parser: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: entity_relation_member: vac: 0 (threshold 523), anl: 0 (threshold 261) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: syslog_p: vac: 990275 (threshold 17695822), anl: 761896 (threshold 8847911) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_ts_dict: vac: 0 (threshold 501), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: slony_test2: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: foo: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: aa: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_toast_16651: vac: 10 (threshold 682), anl: 10 (threshold 341) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_toast_16707: vac: 0 (threshold 504), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: items: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: tagmap: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: tags: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: c: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: e1: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_toast_44848: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: gintest: vac: 0 (threshold 400500), anl: 0 (threshold 200250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_toast_16987: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: entity_attr: vac: 66 (threshold 5752), anl: 75 (threshold 2876) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: t: vac: 0 (threshold 501), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_toast_47422: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: pg_toast_47430: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: meta: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: customer_t: vac: 0 (threshold 501), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: orders: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: entity: vac: 0 (threshold 1154), anl: 1 (threshold 577) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: customer: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: fk1: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.936 PDT <> DEBUG: fk2: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_48182: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_48190: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: customer_ship_addr: vac: 0 (threshold 40500), anl: 0 (threshold 20250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: customer: vac: 0 (threshold 40500), anl: 0 (threshold 20250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: partial: vac: 0 (threshold 400500), anl: 0 (threshold 200250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: bigtable: vac: 0 (threshold 90000504), anl: 0 (threshold 45000252) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45300: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_nodelock: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45314: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45326: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_setsync: vac: 0 (threshold 501), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45343: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_trigger: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_table: vac: 0 (threshold 504), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45366: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_sequence: vac: 0 (threshold 502), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45380: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_node: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_listen: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_path: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_subscribe: vac: 0 (threshold 501), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_set: vac: 0 (threshold 501), anl: 0 (threshold 251) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_log_1: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45441: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45425: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_event: vac: 389 (threshold 640), anl: 0 (threshold 320) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_log_2: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_confirm: vac: 389 (threshold 639), anl: 0 (threshold 320) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45447: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_seqlog: vac: 0 (threshold 1800), anl: 0 (threshold 900) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: pg_toast_45453: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_registry: vac: 130 (threshold 501), anl: 130 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: sl_config_lock: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: ticket: vac: 104 (threshold 2081), anl: 124 (threshold 1041) 94834: 2007-03-29 16:52:26.937 PDT <> DEBUG: ticket: vac: 0 (threshold 798), anl: 1 (threshold 399) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: entity: vac: 0 (threshold 762), anl: 20 (threshold 381) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: entity_relation: vac: 48 (threshold 1622), anl: 140 (threshold 811) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: entity_relation_member: vac: 0 (threshold 1200), anl: 48 (threshold 600) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: entity_category: vac: 0 (threshold 504), anl: 0 (threshold 252) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: meta: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: mytable: vac: 0 (threshold 2000500), anl: 0 (threshold 1000250) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: pg_toast_45632: vac: 0 (threshold 500), anl: 0 (threshold 250) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: CommitTransaction 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997055/1/0, nestlvl: 1, children: <> 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: proc_exit(0) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: shmem_exit(0) 94834: 2007-03-29 16:52:26.938 PDT <> DEBUG: exit(0) 94831: 2007-03-29 16:53:19.149 PDT LOG: EXECUTOR STATISTICS 94831: 2007-03-29 16:53:19.149 PDT DETAIL: ! system usage stats: ! 192.029571 elapsed 80.884389 user 44.286395 system sec ! [80.884389 user 44.294917 sys total] ! 166533/0 [166561/0] filesystem blocks in/out ! 16369/249278 [16379/249909] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [2/6] messages rcvd/sent ! 166243/159053 [166267/159061] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 2647059 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 94831: 2007-03-29 16:53:19.154 PDT DEBUG: CommitTransactionCommand 94831: 2007-03-29 16:53:19.154 PDT DEBUG: CommitTransaction 94831: 2007-03-29 16:53:19.154 PDT DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997051/1/0, nestlvl: 1, children: <> 94831: 2007-03-29 16:53:19.161 PDT LOG: duration: 192081.209 ms statement: select count(*) from bigtable; 94831: 2007-03-29 16:53:20.759 PDT DEBUG: proc_exit(0) 94831: 2007-03-29 16:53:20.759 PDT DEBUG: shmem_exit(0) 94831: 2007-03-29 16:53:20.760 PDT DEBUG: exit(0) 94825: 2007-03-29 16:53:20.785 PDT <> DEBUG: server process (PID 94831) exited with exit code 0 94825: 2007-03-29 16:53:24.372 PDT <> DEBUG: postmaster received signal 15 94825: 2007-03-29 16:53:24.372 PDT <> LOG: received smart shutdown request 94827: 2007-03-29 16:53:24.373 PDT <> LOG: shutting down 94827: 2007-03-29 16:53:24.415 PDT <> LOG: database system is shut down 94827: 2007-03-29 16:53:24.427 PDT <> DEBUG: proc_exit(0) 94827: 2007-03-29 16:53:24.427 PDT <> DEBUG: shmem_exit(0) 94827: 2007-03-29 16:53:24.427 PDT <> DEBUG: exit(0) 94825: 2007-03-29 16:53:24.428 PDT <> DEBUG: proc_exit(0) 94825: 2007-03-29 16:53:24.428 PDT <> DEBUG: shmem_exit(0) 94825: 2007-03-29 16:53:24.726 PDT <> DEBUG: exit(0)