Postgres Pro
Downloads
Home   >   mailing lists

Re: [idea] table partition + hash join - Mailing list pgsql-hackers

From Rosiński Krzysztof 2 - Detal
Subject Re: [idea] table partition + hash join
Date
Msg-id EC285B91B53E5343BDF78D3854C7BBCAB6795894@OPE10MB02.tp.gk.corp.tepenet
Whole thread Raw
In response to [idea] table partition + hash join  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
Responses Re: [idea] table partition + hash join  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-hackers
Tree view 
<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">How to use this optimization ?</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">select * </span><p
class="MsoNormal"><spanlang="EN-US">from table join partitioned_table on (</span><p class="MsoNormal"><span
lang="EN-US"> table.part_id = partitioned_table.id  </span><p class="MsoNormal"><span lang="EN-US">  and
hash_func_mod(table.part_id)= hash_func_mod(partitioned_table.id)</span><p class="MsoNormal"><span
lang="EN-US">)</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US"> </span></div>

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: reaper should restart archiver even on standby
Next
From: Fujii Masao
Date:
Subject: pg_rewind failure by file deletion in source server