Re: [PERFORM] HASH

On Thu, Nov 5, 2015 at 1:11 AM, Artem Tomyuk wrote: > Hi all. > > Is the speed of hash operations stands on the performance of CPU? Yes, but the variation is probably not as much as the raw timing in your example indicates. > Below you can see part from output of explain analyze command > > Inte

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

Sorry for disrupting the thread, i am wondering will it be possible to use BRIN indexes to better estimate distribution? I mean create btree index and brin index, probe brin during planning and estimate if abort early plan with btree will be better. -- Sent via pgsql-performance mailing list

[PERFORM] HASH

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 ro