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.
select version () gives me output something like this
PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red hat 4.1.2-55), 64 bit.
Is there any other way to find
On 07-Jul-2017 7:28 PM, "Adrian Klaver" wrote:
> On 07/07/2017 06:52 AM, Krithika Ve
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 advanc
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 INNE
, "Justin Pryzby" 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 A a WHERE ID IN (SELEC
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
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
postgresql:
https://medium.com/@hariprasathnallsamy/postgresql-materialized-view-incremental-refresh-44d1ca742599
Can someone let me how to do incremental refresh using Write Ahead Log
Thanks,
Krithika
On 07-Nov-2017 12:37 PM, "John R Pierce" wrote:
On 11/6/2017 10:38 PM
