From: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
---|---|
To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Parallel Bitmap scans a bit broken |
Date: | 2017-03-15 16:51:23 |
Message-ID: | CAE2gYzwvsZ1xmUHJ+YsaLaae+rf_Fu1G7yDtGStYfbqr_7tRFQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> With my test case, I could not crash even with this patch applied.
> Can you provide your test case?
Yes:
> hasegeli=# create table r2 as select (random() * 3)::int as i from generate_series(1, 1000000);
> SELECT 1000000
> hasegeli=# create index on r2 using brin (i);
> CREATE INDEX
> hasegeli=# analyze r2;
> ANALYZE
> hasegeli=# explain select * from only r2 where i = 10;
> QUERY PLAN
> -------------------------------------------------------------------------------------
> Gather (cost=2867.50..9225.32 rows=1 width=4)
> Workers Planned: 2
> -> Parallel Bitmap Heap Scan on r2 (cost=1867.50..8225.22 rows=1 width=4)
> Recheck Cond: (i = 10)
> -> Bitmap Index Scan on r2_i_idx (cost=0.00..1867.50 rows=371082 width=0)
> Index Cond: (i = 10)
> (6 rows)
>
> hasegeli=# select * from only r2 where i = 10;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-15 16:55:49 | Re: [COMMITTERS] pgsql: Use asynchronous connect API in libpqwalreceiver |
Previous Message | David Steele | 2017-03-15 16:39:12 | Re: [POC] hash partitioning |