Re: [GENERAL] Incremental refresh - Materialized view

11/6/2017 10:38 PM, Krithika Venkatesh wrote: > I need to implement incremental refresh of materialized view. > > Please let me know how to do the incremental refresh of materialized view > in postgresql 9.5.9 version. > > Is there anything similar to materialized view

[GENERAL] Incremental refresh - Materialized view

Hi, I need to implement incremental refresh of materialized view. Please let me know how to do the incremental refresh of materialized view in postgresql 9.5.9 version. Is there anything similar to materialized view log in postgresql. Thanks in Advance! Regards, Krithika

[GENERAL] Constraint exclusion involving joins

Hi, I understand that the constraints exclusion will work only on constant values. But in my case, I will never pass a constant value to the partitioning key when we query the partition table. Will the partition be still be beneficial in this case. If yes, can you please explain Thanks

Re: [GENERAL] Partitioning (constraint exclusion involving joins)

, "Justin Pryzby" <pry...@telsasoft.com> wrote: On Tue, Jul 25, 2017 at 06:21:43PM +0530, Krithika Venkatesh wrote: > I have a table that is partitioned on a numeric column (ID). > > Partitioning works when I query the table with no joins. > > SELECT * FROM TABLE

[GENERAL] Partitioning

Hi, I have a table that is partitioned on a numeric column (ID). Partitioning works when I query the table with no joins. SELECT * FROM TABLE A a WHERE ID IN (SELECT ID FROM TABLE B b WHERE CREATED_TS = CURRENT_TIMESTAMP) Partitioning doesn't work when I do join. SELECT A.* FROM TABLE A a

[GENERAL] Materialised view - refresh

Hi I have a materialised view which needs to refreshed every half an hour. Is it possible to refresh the view without using triggers. Do we have something similar to DBMS_SCHEDULER.CREATE_JOB in postgresql to create a job that can be scheduled to refresh the views periodically. Thanks in

Re: [GENERAL] Postgresql - commercial version

07/07/2017 06:52 AM, Krithika Venkatesh wrote: > >> Hi, >> >> I have postgreSQL 9.5 installed in the server. Is it possible to find >> whether the installed postgresql is enterprise db or an open source version >> through a query. >> > > Not sure,

[GENERAL] Postgresql - commercial version

Hi, I have postgreSQL 9.5 installed in the server. Is it possible to find whether the installed postgresql is enterprise db or an open source version through a query. Thanks in Advance.