Postgres Pro
Downloads
Home   >   mailing lists

Pre-calculate hash join - Mailing list pgsql-general

From warren@warrenandrachel.com
Subject Pre-calculate hash join
Date
Msg-id 22037187.72981262983490954.JavaMail.root@vcsmail.com
Whole thread Raw
Responses Re: Pre-calculate hash join  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-general
Tree view 
When joining two large tables [common in warehousing], a hash join is commonly selected. Calculating hash values for
themerge phase is CPU intensive. Is there any way to pre-calculate value hashes to save that time? Would it even grant
anyperformance to skip the build phase of the hash join? 

-Warren

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Index question on postgres
Next
From: glaucomag
Date:
Subject: pgadmin save password