Foreign Data Wrapper for HASH TABLE =============================== only build postgres 9.5.3 1. Installation $ export PATH=/usr/local/pgsql/bin/:$PATH make make install 2. Usage ##options "key" is this table primary , value just only this table. hash_idx default size is 8,max size is 16. create extension hash_fdw ; create server hash_server foreign data wrapper hash_fdw ; create foreign table my_hash(id bigint,name text,age int) server hash_server options(key 'id',hash_idx '1'); postgres=# insert into my_hash select 1,'AnAn',26; postgres=# insert into my_hash select 2,'L.Sang',27; postgres=# select * from my_hash ; id | name | age ----+--------+----- 1 | AnAn | 26 2 | L.Sang | 27 (2 rows)