[HACKERS] Shared Memory hash tables only at startup

2017-05-02 Thread hariprasath nallasamy
Hi It is clear that all of the shared memory hash tables are created during startup using *ShmemInitHash() * *(In practice, all creations are done in the postmasterprocess; child processes should always be attaching to existing tables.)* Is there any specific reason to do so or my understanding

[HACKERS] Materialized View Incremental Refresh right join

2016-09-02 Thread hariprasath nallasamy
Hi all Using logical decoding i set up a plugin to refresh materialized views incrementally(only the changes that are did after the previous refresh). I used the approach that oracle uses for fast refresh of materialized view using log table to record delta changes. Mostly i covered for