94759: 2007-03-29 16:36:09.808 PDT <> DEBUG: postgres: PostmasterMain: initial environ dump: 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: ----------------------------------------- 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: MACHTYPE=i386 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: USER=pgsql 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: MAIL=/var/mail/pgsql 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: VENDOR=intel 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: SHLVL=2 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: OLDPWD=/usr/local/pgsql/wd/install 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: HOME=/usr/local/pgsql 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: GROUP=pgsql 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LOGNAME=pgsql 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: _=/usr/local/pgsql/wd/pgsql-ss/bin/pg_ctl 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: BLOCKSIZE=K 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: TERM=xterm 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: PGSYSCONFDIR=/usr/local/pgsql/wd/pgsql-ss/etc 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/pgsql/bin 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: SHELL=/bin/tcsh 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: OSTYPE=FreeBSD 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: PWD=/usr/local/pgsql/wd 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: PGDATA=/usr/local/pgsql/data 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: FTP_PASSIVE_MODE=YES 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: HOSTTYPE=FreeBSD 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LC_COLLATE=C 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LC_CTYPE=C 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LC_MESSAGES=en_US.UTF-8 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LC_MONETARY=C 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LC_NUMERIC=C 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: LC_TIME=C 94759: 2007-03-29 16:36:09.809 PDT <> DEBUG: ----------------------------------------- 94759: 2007-03-29 16:36:09.895 PDT <> LOG: could not load root certificate file "root.crt": No such file or directory 94759: 2007-03-29 16:36:09.895 PDT <> DETAIL: Will not verify client certificates. 94759: 2007-03-29 16:36:09.896 PDT <> DEBUG: invoking IpcMemoryCreate(size=1135042560) 94759: 2007-03-29 16:36:09.967 PDT <> DEBUG: max_safe_fds = 4984, usable_fds = 5000, already_open = 6 94760: 2007-03-29 16:36:09.970 PDT <> LOG: database system was shut down at 2007-03-29 16:36:04 PDT 94760: 2007-03-29 16:36:09.970 PDT <> LOG: checkpoint record is at 81/82695640 94760: 2007-03-29 16:36:09.970 PDT <> LOG: redo record is at 81/82695640; undo record is at 0/0; shutdown TRUE 94760: 2007-03-29 16:36:09.970 PDT <> LOG: next transaction ID: 0/16997020; next OID: 48261 94760: 2007-03-29 16:36:09.970 PDT <> LOG: next MultiXactId: 1; next MultiXactOffset: 0 94760: 2007-03-29 16:36:09.971 PDT <> LOG: database system is ready 94760: 2007-03-29 16:36:09.977 PDT <> DEBUG: transaction ID wrap limit is 2147484171, limited by database "postgres" 94760: 2007-03-29 16:36:09.977 PDT <> DEBUG: proc_exit(0) 94760: 2007-03-29 16:36:09.977 PDT <> DEBUG: shmem_exit(0) 94760: 2007-03-29 16:36:09.978 PDT <> DEBUG: exit(0) 94763: 2007-03-29 16:36:09.982 PDT <> DEBUG: StartTransaction 94763: 2007-03-29 16:36:09.982 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997020/1/0, nestlvl: 1, children: <> 94763: 2007-03-29 16:36:10.000 PDT <> DEBUG: CommitTransaction 94763: 2007-03-29 16:36:10.000 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997020/1/0, nestlvl: 1, children: <> 94763: 2007-03-29 16:36:10.000 PDT <> DEBUG: autovacuum: processing database "pgsql" 94763: 2007-03-29 16:36:10.000 PDT <> DEBUG: StartTransaction 94763: 2007-03-29 16:36:10.000 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997021/1/0, nestlvl: 1, children: <> 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_statistic: vac: 302 (threshold 560), anl: 302 (threshold 280) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_type: vac: 0 (threshold 549), anl: 0 (threshold 274) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 827), anl: 0 (threshold 414) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 270) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94763: 2007-03-29 16:36:10.006 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: pg_auth_members: vac: 0 (threshold 500), anl: 0 (threshold 250) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: CommitTransaction 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997021/1/0, nestlvl: 1, children: <> 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: proc_exit(0) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: shmem_exit(0) 94763: 2007-03-29 16:36:10.007 PDT <> DEBUG: exit(0) 94759: 2007-03-29 16:36:11.451 PDT <> DEBUG: forked new backend, pid=94765 socket=7 94765: 2007-03-29 16:36:11.451 PDT DEBUG: postgres child[94765]: starting with ( 94765: 2007-03-29 16:36:11.451 PDT DEBUG: postgres 94765: 2007-03-29 16:36:11.451 PDT DEBUG: -v196608 94765: 2007-03-29 16:36:11.451 PDT DEBUG: -y 94765: 2007-03-29 16:36:11.451 PDT DEBUG: db02 94765: 2007-03-29 16:36:11.451 PDT DEBUG: ) 94765: 2007-03-29 16:36:11.452 PDT DEBUG: InitPostgres 94765: 2007-03-29 16:36:11.452 PDT DEBUG: StartTransaction 94765: 2007-03-29 16:36:11.452 PDT DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997022/1/0, nestlvl: 1, children: <> 94765: 2007-03-29 16:36:11.457 PDT DEBUG: CommitTransaction 94765: 2007-03-29 16:36:11.457 PDT DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997022/1/0, nestlvl: 1, children: <> 94765: 2007-03-29 16:36:20.117 PDT DEBUG: StartTransactionCommand 94765: 2007-03-29 16:36:20.117 PDT DEBUG: StartTransaction 94765: 2007-03-29 16:36:20.117 PDT DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997023/1/0, nestlvl: 1, children: <> 94765: 2007-03-29 16:36:20.130 PDT DEBUG: PortalRun 94766: 2007-03-29 16:37:11.473 PDT <> DEBUG: StartTransaction 94766: 2007-03-29 16:37:11.474 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997024/1/0, nestlvl: 1, children: <> 94766: 2007-03-29 16:37:11.566 PDT <> DEBUG: CommitTransaction 94766: 2007-03-29 16:37:11.566 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997024/1/0, nestlvl: 1, children: <> 94766: 2007-03-29 16:37:11.566 PDT <> DEBUG: autovacuum: processing database "template1" 94766: 2007-03-29 16:37:11.566 PDT <> DEBUG: StartTransaction 94766: 2007-03-29 16:37:11.567 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997025/1/0, nestlvl: 1, children: <> 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94766: 2007-03-29 16:37:11.568 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_statistic: vac: 302 (threshold 560), anl: 302 (threshold 280) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_type: vac: 0 (threshold 548), anl: 0 (threshold 274) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 826), anl: 0 (threshold 413) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 270) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: pg_auth_members: vac: 0 (threshold 500), anl: 0 (threshold 250) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: CommitTransaction 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997025/1/0, nestlvl: 1, children: <> 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: proc_exit(0) 94766: 2007-03-29 16:37:11.569 PDT <> DEBUG: shmem_exit(0) 94766: 2007-03-29 16:37:11.570 PDT <> DEBUG: exit(0) 94767: 2007-03-29 16:38:11.613 PDT <> DEBUG: StartTransaction 94767: 2007-03-29 16:38:11.628 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997026/1/0, nestlvl: 1, children: <> 94767: 2007-03-29 16:38:11.664 PDT <> DEBUG: CommitTransaction 94767: 2007-03-29 16:38:11.664 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997026/1/0, nestlvl: 1, children: <> 94767: 2007-03-29 16:38:11.664 PDT <> DEBUG: autovacuum: processing database "db02" 94767: 2007-03-29 16:38:11.664 PDT <> DEBUG: StartTransaction 94767: 2007-03-29 16:38:11.664 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997027/1/0, nestlvl: 1, children: <> 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_toast_1255: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_toast_2619: vac: 5 (threshold 511), anl: 6 (threshold 255) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_statistic: vac: 554 (threshold 623), anl: 554 (threshold 311) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_type: vac: 0 (threshold 589), anl: 0 (threshold 294) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 1264), anl: 0 (threshold 632) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_proc: vac: 0 (threshold 966), anl: 0 (threshold 483) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_class: vac: 0 (threshold 608), anl: 0 (threshold 304) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_attrdef: vac: 0 (threshold 514), anl: 0 (threshold 257) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 532), anl: 0 (threshold 266) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 503), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: tt1: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: tt2: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.711 PDT <> DEBUG: pg_toast_46612: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity_attr: vac: 0 (threshold 1963), anl: 156 (threshold 981) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_index: vac: 0 (threshold 546), anl: 0 (threshold 273) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_operator: vac: 0 (threshold 649), anl: 0 (threshold 324) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 522), anl: 0 (threshold 261) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_amop: vac: 0 (threshold 599), anl: 0 (threshold 299) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 552), anl: 0 (threshold 276) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_largeobject: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 262) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 518), anl: 0 (threshold 259) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 531), anl: 0 (threshold 265) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_listener: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_description: vac: 0 (threshold 896), anl: 0 (threshold 448) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_cast: vac: 0 (threshold 552), anl: 0 (threshold 276) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 506), anl: 0 (threshold 253) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1899), anl: 0 (threshold 950) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_auth_members: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: ttime: vac: 0 (threshold 503), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: slony_test: vac: 0 (threshold 100502), anl: 0 (threshold 50251) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: t10: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity_category: vac: 0 (threshold 503), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: empty: vac: 0 (threshold 1626), anl: 0 (threshold 813) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: t145: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: ti1: vac: 0 (threshold 200500), anl: 0 (threshold 100250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: ti2: vac: 0 (threshold 200500), anl: 0 (threshold 100250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity_relation: vac: 50 (threshold 3478), anl: 53 (threshold 1739) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: a: vac: 0 (threshold 2000500), anl: 0 (threshold 1000250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: b: vac: 0 (threshold 2000500), anl: 0 (threshold 1000250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity_relation_member: vac: 0 (threshold 2100), anl: 50 (threshold 1050) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: meta: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity: vac: 0 (threshold 516), anl: 0 (threshold 258) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: pg_toast_17040: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity_attr: vac: 0 (threshold 547), anl: 0 (threshold 274) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: tmp2: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.712 PDT <> DEBUG: entity_category: vac: 0 (threshold 504), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: entity_relation: vac: 0 (threshold 539), anl: 0 (threshold 270) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_ts_cfg: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_ts_cfgmap: vac: 0 (threshold 519), anl: 0 (threshold 260) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_ts_parser: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: entity_relation_member: vac: 0 (threshold 523), anl: 0 (threshold 261) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: syslog_p: vac: 990275 (threshold 17695822), anl: 761896 (threshold 8847911) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_ts_dict: vac: 0 (threshold 501), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: slony_test2: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: foo: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: aa: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_16651: vac: 10 (threshold 682), anl: 10 (threshold 341) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_16707: vac: 0 (threshold 504), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: items: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: tagmap: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: tags: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: c: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: e1: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_44848: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: gintest: vac: 0 (threshold 400500), anl: 0 (threshold 200250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_16987: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: entity_attr: vac: 66 (threshold 5752), anl: 75 (threshold 2876) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: t: vac: 0 (threshold 501), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_47422: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_47430: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: meta: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: customer_t: vac: 0 (threshold 501), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: orders: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: entity: vac: 0 (threshold 1154), anl: 1 (threshold 577) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: customer: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: fk1: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: fk2: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.713 PDT <> DEBUG: pg_toast_48182: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_48190: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: customer_ship_addr: vac: 0 (threshold 40500), anl: 0 (threshold 20250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: customer: vac: 0 (threshold 40500), anl: 0 (threshold 20250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: partial: vac: 0 (threshold 400500), anl: 0 (threshold 200250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: bigtable: vac: 0 (threshold 90000504), anl: 0 (threshold 45000252) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45300: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_nodelock: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45314: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45326: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_setsync: vac: 0 (threshold 501), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45343: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_trigger: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_table: vac: 0 (threshold 504), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45366: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_sequence: vac: 0 (threshold 502), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45380: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_node: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_listen: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_path: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_subscribe: vac: 0 (threshold 501), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_set: vac: 0 (threshold 501), anl: 0 (threshold 251) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_log_1: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45441: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45425: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_event: vac: 389 (threshold 640), anl: 0 (threshold 320) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_log_2: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_confirm: vac: 389 (threshold 639), anl: 0 (threshold 320) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45447: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_seqlog: vac: 0 (threshold 1800), anl: 0 (threshold 900) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45453: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_registry: vac: 130 (threshold 501), anl: 130 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: sl_config_lock: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: ticket: vac: 104 (threshold 2081), anl: 124 (threshold 1041) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: ticket: vac: 0 (threshold 798), anl: 1 (threshold 399) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: entity: vac: 0 (threshold 762), anl: 20 (threshold 381) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: entity_relation: vac: 48 (threshold 1622), anl: 140 (threshold 811) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: entity_relation_member: vac: 0 (threshold 1200), anl: 48 (threshold 600) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: entity_category: vac: 0 (threshold 504), anl: 0 (threshold 252) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: meta: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: mytable: vac: 0 (threshold 2000500), anl: 0 (threshold 1000250) 94767: 2007-03-29 16:38:11.714 PDT <> DEBUG: pg_toast_45632: vac: 0 (threshold 500), anl: 0 (threshold 250) 94767: 2007-03-29 16:38:11.715 PDT <> DEBUG: CommitTransaction 94767: 2007-03-29 16:38:11.715 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997027/1/0, nestlvl: 1, children: <> 94767: 2007-03-29 16:38:11.715 PDT <> DEBUG: proc_exit(0) 94767: 2007-03-29 16:38:11.715 PDT <> DEBUG: shmem_exit(0) 94767: 2007-03-29 16:38:11.715 PDT <> DEBUG: exit(0) 94759: 2007-03-29 16:38:53.703 PDT <> DEBUG: forked new backend, pid=94768 socket=7 94768: 2007-03-29 16:38:53.703 PDT <[unknown]> LOG: incomplete startup packet 94768: 2007-03-29 16:38:53.710 PDT <[unknown]> DEBUG: proc_exit(0) 94768: 2007-03-29 16:38:53.710 PDT <[unknown]> DEBUG: shmem_exit(0) 94768: 2007-03-29 16:38:53.710 PDT <[unknown]> DEBUG: exit(0) 94759: 2007-03-29 16:38:53.711 PDT <> DEBUG: server process (PID 94768) exited with exit code 0 94765: 2007-03-29 16:39:30.475 PDT LOG: EXECUTOR STATISTICS 94765: 2007-03-29 16:39:30.475 PDT DETAIL: ! system usage stats: ! 190.345030 elapsed 78.640123 user 44.850213 system sec ! [78.640123 user 44.858471 sys total] ! 166533/0 [166540/0] filesystem blocks in/out ! 16369/249277 [16379/249915] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [2/6] messages rcvd/sent ! 166235/159212 [166243/159215] 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 94765: 2007-03-29 16:39:30.482 PDT DEBUG: CommitTransactionCommand 94765: 2007-03-29 16:39:30.482 PDT DEBUG: CommitTransaction 94765: 2007-03-29 16:39:30.482 PDT DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997023/1/0, nestlvl: 1, children: <> 94765: 2007-03-29 16:39:30.482 PDT LOG: duration: 190365.258 ms statement: select count(*) from bigtable; 94770: 2007-03-29 16:39:53.740 PDT <> DEBUG: StartTransaction 94770: 2007-03-29 16:39:53.740 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997028/1/0, nestlvl: 1, children: <> 94770: 2007-03-29 16:39:53.788 PDT <> DEBUG: CommitTransaction 94770: 2007-03-29 16:39:53.788 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997028/1/0, nestlvl: 1, children: <> 94770: 2007-03-29 16:39:53.789 PDT <> DEBUG: autovacuum: processing database "postgres" 94770: 2007-03-29 16:39:53.789 PDT <> DEBUG: StartTransaction 94770: 2007-03-29 16:39:53.789 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997029/1/0, nestlvl: 1, children: <> 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.790 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94770: 2007-03-29 16:39:53.794 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94770: 2007-03-29 16:39:53.794 PDT <> DEBUG: pg_statistic: vac: 303 (threshold 561), anl: 303 (threshold 280) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_type: vac: 0 (threshold 549), anl: 0 (threshold 274) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 827), anl: 0 (threshold 414) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 271) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: foo: vac: 0 (threshold 200501), anl: 0 (threshold 100250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: CommitTransaction 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997029/1/0, nestlvl: 1, children: <> 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: proc_exit(0) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: shmem_exit(0) 94770: 2007-03-29 16:39:53.795 PDT <> DEBUG: exit(0) 94774: 2007-03-29 16:40:53.802 PDT <> DEBUG: StartTransaction 94774: 2007-03-29 16:40:53.802 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997030/1/0, nestlvl: 1, children: <> 94774: 2007-03-29 16:40:53.834 PDT <> DEBUG: CommitTransaction 94774: 2007-03-29 16:40:53.834 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997030/1/0, nestlvl: 1, children: <> 94774: 2007-03-29 16:40:53.834 PDT <> DEBUG: autovacuum: processing database "pgsql" 94774: 2007-03-29 16:40:53.834 PDT <> DEBUG: StartTransaction 94774: 2007-03-29 16:40:53.834 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997031/1/0, nestlvl: 1, children: <> 94774: 2007-03-29 16:40:53.869 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94774: 2007-03-29 16:40:53.869 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94774: 2007-03-29 16:40:53.869 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94774: 2007-03-29 16:40:53.869 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_authid: vac: 0 (threshold 505), anl: 0 (threshold 252) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_statistic: vac: 302 (threshold 560), anl: 302 (threshold 280) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_type: vac: 0 (threshold 549), anl: 0 (threshold 274) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 827), anl: 0 (threshold 414) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 270) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: pg_auth_members: vac: 0 (threshold 500), anl: 0 (threshold 250) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: CommitTransaction 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997031/1/0, nestlvl: 1, children: <> 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: proc_exit(0) 94774: 2007-03-29 16:40:53.870 PDT <> DEBUG: shmem_exit(0) 94774: 2007-03-29 16:40:53.871 PDT <> DEBUG: exit(0) 94775: 2007-03-29 16:41:53.876 PDT <> DEBUG: StartTransaction 94775: 2007-03-29 16:41:53.876 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997032/1/0, nestlvl: 1, children: <> 94775: 2007-03-29 16:41:53.904 PDT <> DEBUG: CommitTransaction 94775: 2007-03-29 16:41:53.904 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997032/1/0, nestlvl: 1, children: <> 94775: 2007-03-29 16:41:53.904 PDT <> DEBUG: autovacuum: processing database "template1" 94775: 2007-03-29 16:41:53.904 PDT <> DEBUG: StartTransaction 94775: 2007-03-29 16:41:53.904 PDT <> DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 16997033/1/0, nestlvl: 1, children: <> 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: sql_sizing: vac: 0 (threshold 505), anl: 0 (threshold 252) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: sql_features: vac: 0 (threshold 588), anl: 0 (threshold 294) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_toast_2618: vac: 0 (threshold 516), anl: 0 (threshold 258) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_toast_2619: vac: 8 (threshold 502), anl: 8 (threshold 251) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: sql_implementation_info: vac: 0 (threshold 502), anl: 0 (threshold 251) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: sql_languages: vac: 0 (threshold 501), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: sql_packages: vac: 0 (threshold 502), anl: 0 (threshold 251) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: sql_parts: vac: 0 (threshold 502), anl: 0 (threshold 251) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_statistic: vac: 302 (threshold 560), anl: 302 (threshold 280) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_type: vac: 0 (threshold 548), anl: 0 (threshold 274) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_attribute: vac: 0 (threshold 826), anl: 0 (threshold 413) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_proc: vac: 0 (threshold 886), anl: 0 (threshold 443) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_class: vac: 0 (threshold 541), anl: 0 (threshold 270) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_autovacuum: vac: 0 (threshold 500), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_constraint: vac: 0 (threshold 500), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_inherits: vac: 0 (threshold 500), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_index: vac: 0 (threshold 515), anl: 0 (threshold 258) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_operator: vac: 0 (threshold 633), anl: 0 (threshold 317) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_opclass: vac: 0 (threshold 520), anl: 0 (threshold 260) 94775: 2007-03-29 16:41:53.937 PDT <> DEBUG: pg_am: vac: 0 (threshold 501), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_amop: vac: 0 (threshold 589), anl: 0 (threshold 294) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_amproc: vac: 0 (threshold 545), anl: 0 (threshold 272) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_language: vac: 0 (threshold 501), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_aggregate: vac: 0 (threshold 523), anl: 0 (threshold 261) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_rewrite: vac: 0 (threshold 515), anl: 0 (threshold 257) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_trigger: vac: 0 (threshold 501), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_description: vac: 0 (threshold 851), anl: 0 (threshold 426) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_cast: vac: 0 (threshold 551), anl: 0 (threshold 276) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_namespace: vac: 0 (threshold 501), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_conversion: vac: 0 (threshold 525), anl: 0 (threshold 262) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_depend: vac: 0 (threshold 1362), anl: 0 (threshold 681) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: pg_database: vac: 0 (threshold 501), anl: 0 (threshold 250) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: CommitTransaction 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 16997033/1/0, nestlvl: 1, children: <> 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: proc_exit(0) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: shmem_exit(0) 94775: 2007-03-29 16:41:53.938 PDT <> DEBUG: exit(0) 94765: 2007-03-29 16:42:10.544 PDT DEBUG: proc_exit(0) 94765: 2007-03-29 16:42:10.544 PDT DEBUG: shmem_exit(0) 94765: 2007-03-29 16:42:10.544 PDT DEBUG: exit(0) 94759: 2007-03-29 16:42:10.556 PDT <> DEBUG: server process (PID 94765) exited with exit code 0 94759: 2007-03-29 16:42:14.914 PDT <> DEBUG: postmaster received signal 15 94759: 2007-03-29 16:42:14.914 PDT <> LOG: received smart shutdown request 94761: 2007-03-29 16:42:14.915 PDT <> LOG: shutting down 94761: 2007-03-29 16:42:14.948 PDT <> LOG: database system is shut down 94761: 2007-03-29 16:42:14.966 PDT <> DEBUG: proc_exit(0) 94761: 2007-03-29 16:42:14.966 PDT <> DEBUG: shmem_exit(0) 94761: 2007-03-29 16:42:14.966 PDT <> DEBUG: exit(0) 94759: 2007-03-29 16:42:14.967 PDT <> DEBUG: proc_exit(0) 94759: 2007-03-29 16:42:14.967 PDT <> DEBUG: shmem_exit(0) 94759: 2007-03-29 16:42:15.274 PDT <> DEBUG: exit(0)