ext2

application/octet-stream

Filename: ext2
Type: application/octet-stream
Part: 2
Message: Re: bad performance on irix
dbx version 7.3.1 68542_Oct26 MR Oct 26 2000 17:50:34
Process  1902 (postgres) stopped at [__syscall:20 +0x8,0xfaeab08]
	 Source (of /xlv51/6.5.12f/work/irix/lib/libc/libc_n32_M4/sys/syscall.s) not available for Process  1902
>  0 __syscall(0x41d, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/xlv51/6.5.12f/work/irix/lib/libc/libc_n32_M4/sys/syscall.s":20, 0xfaeab08]
   1 IpcSemaphoreLock(0xe, 0x2, 0x0, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/storage/ipc/ipc.c":422, 0x1011b27c]
   2 LWLockAcquire(0x0, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/storage/lmgr/lwlock.c":293, 0x1012378c]
   3 ReadBufferInternal(0x10432c50, 0x14, 0x0, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/storage/buffer/bufmgr.c":183, 0x10113dd4]
   4 ReadBuffer(0x41d, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/storage/buffer/bufmgr.c":127, 0x101139f0]
   5 heap_fetch(0x0, 0x104d5688, 0x104d5f54, 0x0, 0x0, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/access/heap/heapam.c":873, 0x1003b978]
   6 IndexNext(0x0, 0x2, 0x0, 0x0, 0x1, 0x0, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeIndexscan.c":176, 0x100bb4c0]
   7 ExecScan(0x0, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execScan.c":95, 0x100b56a4]
   8 ExecIndexScan(0x41d, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeIndexscan.c":283, 0x100bb784]
   9 ExecProcNode(0x104d1d58, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execProcnode.c":289, 0x100b2b78
More (n if no)?]
   10 ExecMergeJoin(0x104d37f8, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0x0, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeMergejoin.c":782, 0x100bd0c8]
   11 ExecProcNode(0x104d37f8, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execProcnode.c":308, 0x100b2b50]
   12 ExecSort(0x0, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeSort.c":162, 0x100bf2d8]
   13 ExecProcNode(0x104d41f0, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execProcnode.c":327, 0x100b2b00]
   14 ExecGroupEveryTuple(0x0, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeGroup.c":109, 0x100bff84]
   15 ExecGroup(0x41d, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeGroup.c":57, 0x100bfea8]
   16 ExecProcNode(0x104d4278, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execProcnode.c":343, 0x100b2a9c]
   17 ExecAgg(0x0, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/nodeAgg.c":517, 0x100b8838]
More (n if no)?   18 ExecProcNode(0x104d4300, 0x0, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execProcnode.c":347, 0x100b2aec]
   19 ExecutePlan(0x104d5600, 0x2, 0x1, 0x0, 0x1, 0x0, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execMain.c":976, 0x100b140c]
   20 ExecutorRun(0x41d, 0x104d5600, 0x1, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/executor/execMain.c":199, 0x100b04c4]
   21 ProcessQuery(0x104d55e8, 0x104d5600, 0x2, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/tcop/pquery.c":293, 0x1012abfc]
   22 pg_exec_query_string(0x0, 0x2, 0x1045fc20, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/tcop/postgres.c":781, 0x10128e88]
   23 PostgresMain(0x1022dff4, 0x1022dff2, 0x1044c160, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/tcop/postgres.c":1849, 0x10129cb0]
   24 DoBackend(0x1022f16c, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/postmaster/postmaster.c":2205, 0x10100bcc]
   25 BackendStartup(0x0, 0x2, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/postmaster/postmaster.c":1873, 0x1010080c]
More (n if no)?   26 ServerLoop(0x41d, 0x85, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/postmaster/postmaster.c":976, 0x100ff3a8]
   27 PostmasterMain(0x1, 0x100ffd70, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/postmaster/postmaster.c":770, 0x100fe9e8]
   28 main(0x1, 0x7fff2f44, 0xe, 0x0, 0x1, 0x1022dff1, 0xffffffff, 0x0) ["/home/lamigo/postgresql-7.2b4/src/backend/main/main.c":206, 0x100cc3c4]
   29 __start() ["/xlv55/kudzu-apr12/work/irix/lib/libc/libc_n32_M4/csu/crt1text.s":177, 0x1002a0e8]