[email protected] writes: > When joining two large tables [common in warehousing], a hash join is > commonly selected. Calculating hash values for the merge phase is CPU > intensive. Is there any way to pre-calculate value hashes to save that > time? Would it even grant any performance to skip the build phase of > the hash join?
Maybe maintaining a materialized view then using it in the queries would be sufficient to solve your problem? -- dim -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
