HASH

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: HASH
Date: 2015-11-05 09:11:10
Message-ID: CANYYVqKEC3mvrK+cJQgHiPnR6Vq+zs4vMqzyodcQ-Ts_s+K74A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all.

Is the speed of hash operations stands on the performance of CPU?
Below you can see part from output of explain analyze command

*Intel(R) Xeon(R) CPU E7520 @ 1.87GHz*
" -> Hash (cost=337389.43..337389.43 rows=3224443 width=34)
(actual time=15046.382..15046.382 rows=3225191 loops=1)"
" Buckets: 524288 Batches: 1 Memory Usage: 207874kB"

*Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz*

" -> Hash (cost=340758.94..340758.94 rows=3191894 width=34)
(actual time=2692.878..2692.878 rows=3192103 loops=1)"
" Buckets: 524288 Batches: 1 Memory Usage: 205742kB"

*Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz*
" -> Hash (cost=337389.43..337389.43 rows=3224443 width=34)
(actual time=8559.849..8559.849 rows=3225293 loops=1)"
" Buckets: 524288 Batches: 1 Memory Usage: 207881kB"

*Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz*
" -> Hash (cost=356613.23..356613.23 rows=3224623 width=40)
(actual time=3635.931..3635.931 rows=3224623 loops=1)"
" Buckets: 524288 Batches: 1 Memory Usage: 207838kB"

Thanks.

Responses

  • Re: HASH at 2015-11-05 11:24:24 from Jeff Janes

Browse pgsql-performance by date

  From Date Subject
Next Message Evgeniy Shishkin 2015-11-05 09:45:31 Re: Yet another abort-early plan disaster on 9.3
Previous Message Guido Niewerth 2015-11-03 10:58:26 Re: Slow query in trigger function