BUG #13791: postgresql 9.5 beta2 brin bug (cann't auto update)

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13791: postgresql 9.5 beta2 brin bug (cann't auto update)
Date: 2015-12-03 01:20:48
Message-ID: 20151203012048.5892.94586@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13791
Logged by: digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOS 6.x x64
Description:

ostgres=# create unlogged table test(id serial8, info text, crt_time
timestamp);
CREATE TABLE
postgres=# alter sequence test_id_seq cache 10000000;
ALTER SEQUENCE
postgres=# create index idx_test on test using brin (id) with
(pages_per_range =1);
CREATE INDEX

$vi test.sql
insert into test (info) select null from generate_series(1,10000000);

$pgbench -M prepared -n -r -P 1 -f ./test.sql -c 1 -j 1 -t 1000

the brin index cann't auto update, when i create it 224k. and when test some
times elapse, it's also 224k.
and when i query , select * from test where id=1000;

postgres=# explain analyze select * from test where id=1000;
QUERY PLAN

--------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on test (cost=12.01..16.02 rows=1 width=48) (actual
time=47.930..73214.043 rows=1 loops=1)
Recheck Cond: (id = 1000)
Rows Removed by Index Recheck: 489999090
Heap Blocks: lossy=539248
-> Bitmap Index Scan on idx_test (cost=0.00..12.01 rows=1 width=0)
(actual time=47.818..47.818 rows=5392480 loops=1)
Index Cond: (id = 1000)
Planning time: 0.282 ms
Execution time: 73214.128 ms
(8 rows)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-12-03 07:30:29 Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement.
Previous Message pbelbin 2015-12-02 21:02:20 BUG #13790: last row of limit/offset result produces duplicates