[HACKERS] Extract Jsonb key and values

2016-06-23 Thread hari.prasath
Hi all, I am having jsonb as C character string received by WAL decoding and want to extract all its key and value pairs. Which is the best approach for extracting keys and its values? i) Converting the C string to a PostgreSQL jsonb object ii) Using open-source json-c

[HACKERS] Logical Decoding - Execute join query

2016-04-01 Thread hari.prasath
Hi all, I tried to execute a join query using SPI_execute() in logical decoding part and got inconsistent values (i am referring it as inconsistent since it is returning the old values which is present at the postgresql server start). My data directory has to tables table1(a

[HACKERS] Incremental refresh of materialized view - Patch

2016-05-12 Thread hari.prasath
Hi all I am building a patch to refresh materialized view incrementally from the change set decoded by using logical decoding from WAL. As of now i can able to generate the changes that has to be updated in the materialized view but the thing was it not possible to do any

Re: [HACKERS] Incremental refresh of materialized view - Patch

2016-05-12 Thread hari.prasath
Hi all I am building a patch to refresh materialized view incrementally from the change set decoded by using logical decoding from WAL. As of now i can able to generate the changes that has to be updated in the materialized view but the thing was it not possible to do any

[HACKERS] full table delete query

2016-05-03 Thread hari.prasath
Hi all, How postgresql handles full table delete in terms of loading the full table in these scenarios consider one big table(tablename: bigtable) and the query will be delete from bigtable; 1)which doesn't have any foreign table reference with any other tables 2)And when this

[HACKERS] Delete query on materialized view

2016-05-05 Thread hari.prasath
Hi all I am trying to delete/insert a row on materialized view which has join from a UDF by using SPI_execute. Materialized views are not allowed to do any DML changes once created,so by bypassed that check by enabling MatViewIncrementalMaintenanceIsEnabled. so DML queries