Re: [HACKERS] Bitmap index thoughts (another segfault)

2007-04-08 Thread Gavin Sherry 

 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

Thanks Mark. I tracked this down. I'll post a new patch soon.

Gavin

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [HACKERS] Bitmap index thoughts (another segfault)

2007-04-08 Thread Gavin Sherry 
On Sat, 7 Apr 2007, Mark Kirkwood wrote:

 Mark Kirkwood wrote:
 bitmap=# SELECT count(*) FROM bitmaptest
 WHERE val1 in (1,7)
 AND val0 IN (4,3)
 ;

 ERROR:  XX000: unknown stream type 2
 LOCATION:  stream_add_node, tidbitmap.c:1033

Thanks. Turned out to be a typo in stream_add_node()! I'll post a new
patch soon. Thanks for the test kit and your testing!

Gavin

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [HACKERS] Bitmap index thoughts (another segfault)

2007-04-06 Thread Mark Kirkwood 

Mark Kirkwood wrote:
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  0x 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



Not a SIGSEGV but another stream related issue:

bitmap=# \d bitmaptest;
  Table public.bitmaptest
 Column |  Type   | Modifiers
+-+---
 id | integer | not null
 val0   | integer |
 val1   | integer |
 val2   | integer |
 fil| text|
Indexes:
bitmaptest_id btree (id)
bitmaptest_val0 bitmap (val0)
bitmaptest_val1 bitmap (val1)
bitmaptest_val2 bitmap (val2)
bitmap=# SELECT count(*) FROM bitmaptest
   WHERE val1 in (1,7)
   AND val0 IN (4,3)
   ;

ERROR:  XX000: unknown stream type 2
LOCATION:  stream_add_node, tidbitmap.c:1033

I could not reproduce this with the TPC-H dataset, so here's a link to 
the files to generate this one:

http://homepages.paradise.net.nz/markir/download/bizgres/bitmaptest.tar.gz

Cheers

Mark

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [HACKERS] Bitmap index thoughts (another segfault)

2007-04-05 Thread Mark Kirkwood 
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  0x 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



---(end of broadcast)---
TIP 6: explain analyze is your friend