| 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: | Whole Thread | Raw Message | 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)
| 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 |