[HACKERS] Materialized View Incremental Refresh right join

[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 single table and for join(left and right) its an
ideal solution but whenever a right join comes to play a role, its hard to
get these delta change. *Any insights so that i get to proceed further..?*

P.S: For left join Foreign key constraint is followed
Example the view joining 3 tables as [T1 left join T2 left join T3]
Foreign key constraints are imposed so that, a key in T1 is deleted only
after the same keys in T2 and T3 are deleted


Happy weekend
-harry

[HACKERS] Shared Memory hash tables only at startup

[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 was wrong(we can
create shared memory hash table at run time too?)



TIA
 harry