From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | Gavin Sherry <swm(at)alcove(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Bitmap index thoughts (another segfault) |
Date: | 2007-04-06 00:17:51 |
Message-ID: | 461591AF.1050901@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm seeing a segfault on a size TPC-H size 10 database. The patch and
code are:
- bitmap patch from 12 Mar
- 8.3 dev from 27 Mar
SELECT count(distinct(o_orderkey))
FROM orders orders_alias
WHERE o_orderpriority IN ('1-URGENT', '3-MEDIUM') AND o_orderstatus='P';
(gdb) bt
#0 0x00000000 in ?? ()
#1 0x08155eb5 in bitmap_stream_free (opaque=0x84e4070) at tidbitmap.c:1336
#2 0x08142914 in ExecEndBitmapHeapScan (node=0x8405548)
at nodeBitmapHeapscan.c:463
#3 0x0813789a in ExecutorEnd (queryDesc=0x83ed948) at execMain.c:992
#4 0x081134ef in PortalCleanup (portal=0x83ee018) at portalcmds.c:302
#5 0x0823e2d2 in PortalDrop (portal=0x83ee018, isTopCommit=0 '\0')
at portalmem.c:382
#6 0x081b2182 in exec_simple_query (
query_string=0x83a8018 "SELECT count(distinct(o_orderkey))\nFROM
orders orders_alias\nWHERE o_orderpriority IN ('1-URGENT', '3-MEDIUM')
AND o_orderstatus='P';") at postgres.c:964
#7 0x081b4350 in PostgresMain (argc=4, argv=0x833a638,
username=0x833a610 "postgres") at postgres.c:3488
#8 0x0818faab in ServerLoop () at postmaster.c:2985
#9 0x081911b1 in PostmasterMain (argc=1, argv=0xbfbfec30) at
postmaster.c:967
#10 0x08153592 in main (argc=1, argv=0xbfbfec30) at main.c:188
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2007-04-06 02:02:56 | Re: What X86/X64 OS's do we need coverage for? |
Previous Message | Larry Rosenman | 2007-04-05 23:28:39 | Re: What X86/X64 OS's do we need coverage for? |