Hello Tom, Thanks for your help. I ran a backtrace as you suggested. Following is the output of the gdb session. John --------------------------- [root@interage bin]# gdb /usr/bin/postgres 31699 GNU gdb Red Hat Linux (5.3.90-0.20030710.41rh) Copyright 2003 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-redhat-linux-gnu"... (no debugging symbols found)...Using host libthread_db library "/lib/tls/libthread_db.so.1". Attaching to program: /usr/bin/postgres, process 31699 Reading symbols from /lib/libpam.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libpam.so.0 Reading symbols from /lib/libssl.so.4...(no debugging symbols found)...done. Loaded symbols for /lib/libssl.so.4 Reading symbols from /lib/libcrypto.so.4...(no debugging symbols found)...done. Loaded symbols for /lib/libcrypto.so.4 Reading symbols from /usr/lib/libkrb5.so.3...(no debugging symbols found)... done. Loaded symbols for /usr/lib/libkrb5.so.3 Reading symbols from /lib/libcom_err.so.2...(no debugging symbols found)... done. Loaded symbols for /lib/libcom_err.so.2 Reading symbols from /usr/lib/libz.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/lib/libreadline.so.4... (no debugging symbols found)...done. Loaded symbols for /usr/lib/libreadline.so.4 Reading symbols from /lib/libtermcap.so.2...(no debugging symbols found)... done. Loaded symbols for /lib/libtermcap.so.2 Reading symbols from /lib/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libresolv.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libresolv.so.2 Reading symbols from /lib/libnsl.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/libnsl.so.1 ---Type <return> to continue, or q <return> to quit--- Reading symbols from /lib/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/tls/libm.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/tls/libm.so.6 Reading symbols from /lib/tls/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/tls/libc.so.6 Reading symbols from /usr/lib/libgssapi_krb5.so.2... (no debugging symbols found)...done. Loaded symbols for /usr/lib/libgssapi_krb5.so.2 Reading symbols from /usr/lib/libk5crypto.so.3... (no debugging symbols found)...done. Loaded symbols for /usr/lib/libk5crypto.so.3 Reading symbols from /lib/ld-linux.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/libnss_files.so.2...(no debugging symbols found)... done. Loaded symbols for /lib/libnss_files.so.2 0x00847c32 in _dl_sysinfo_int80 () from /lib/ld-linux.so.2 (gdb) b errfinish Breakpoint 1 at 0x81e6056 (gdb) cont Continuing. Breakpoint 1, 0x081e6056 in errfinish () (gdb) bt #0 0x081e6056 in errfinish () #1 0x081e6e66 in elog_finish () #2 0x081f5112 in MemoryContextAlloc () #3 0x080758d0 in gistinsert () #4 0x08073bac in gistinsert () #5 0x0807396c in gistinsert () #6 0x0807396c in gistinsert () #7 0x08073865 in gistinsert () #8 0x08073732 in gistinsert () #9 0x081ead7b in OidFunctionCall6 () #10 0x080831c5 in index_insert () #11 0x0810f1ea in ExecInsertIndexTuples () #12 0x081092e4 in ExecEndPlan () #13 0x08108aca in ExecEndPlan () #14 0x08107c38 in ExecutorRun () #15 0x0817e00d in ProcessQuery () #16 0x0817eaf7 in PortalRun () #17 0x0817e47f in PortalRun () #18 0x0817ad54 in pg_plan_queries () #19 0x0817d2c0 in PostgresMain () #20 0x08157345 in ClosePostmasterPorts () #21 0x08156d43 in ClosePostmasterPorts () #22 0x08155218 in PostmasterMain () ---Type <return> to continue, or q <return> to quit--- #23 0x081548a4 in PostmasterMain () #24 0x08124dc6 in main () (gdb) ----------------------------- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
