| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | speedup tidbitmap patch: hash BlockNumber |
| Date: | 2014-10-22 13:14:43 |
| Message-ID: | 5447ADC3.6000408@sigaev.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Just replace tag_hash in tidbitmap which uses hash_any to direct call of
hash_uint32, it saves ~5% of execution time.
An example:
# create extension btree_gin;
# select (v / 10)::int4 as i into t from generate_series(1, 5000000) as v;
# create index idx on t using gin (i);
# set enable_seqscan = off;
# explain analyze select * from t where i >= 0;
without patch: Execution time: 2427.692 ms
with patch: Execution time: 2319.376 ms
# explain analyze select * from t where i >= 100 and i<= 100;
without patch: Execution time: 524.441 ms
with patch: Execution time: 504.478 ms
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| Attachment | Content-Type | Size |
|---|---|---|
| tbm_blocknumber-2.patch.gz | application/x-gzip | 572 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dag-Erling Smørgrav | 2014-10-22 13:16:56 | Re: [PATCH] add ssl_protocols configuration option |
| Previous Message | Dag-Erling Smørgrav | 2014-10-22 13:14:26 | Re: [PATCH] add ssl_protocols configuration option |