Re: Watching for view changes

Hi! On Fri, Dec 21, 2018 at 11:10 PM George Neuner wrote: > A materialized view IS exactly such a deliberate cache of results from > applying a view. It is a real table that can be monitored for changes > using INSERT, UPDATE and/or DELETE triggers. Caching is needed if you want to compute a di

Re: Watching for view changes

On Fri, 21 Dec 2018 20:49:23 -0800, Mitar wrote: >On Thu, Dec 20, 2018 at 6:28 PM George Neuner wrote: > >> The difficulty is that views are not guaranteed to be updateable. > >What you mean by that? I mean, just to be clear. I care only about >read-only views. The changes to views I care about

Re: Watching for view changes

Hi! Thanks for more responses. On Thu, Dec 20, 2018 at 6:28 PM George Neuner wrote: > >You mean that for every SQL query I am making to a database, I would > >manually determine which tables are involved and then setup triggers > >with NOTIFY that the SELECT might have changed? > > You can just

Re: Watching for view changes

Hi! On Thu, Dec 20, 2018 at 12:54 PM Kevin Brannen wrote: > Hmm, I guess I could see that as long as the DB wasn't too [write] busy, > else you'd be flooded with notifications. > Sure. But this could be resolved by allowing notifications to be batched together. Debounce them. So could maybe con

Re: Amazon Aurora

It might be and Aurora issue, but AFAIK, the only difference with the mainstream PostgreSQL project is their storage implementation. What do you mean by slow? each and every query takes longer than it should? have you analyzed particular execution plans? On Thu, Dec 20, 2018 at 3:03 PM Ravi Krishn

Re: Change from 9.6 to 11?

On Thu, Dec 20, 2018 at 10:12 PM Adrian Klaver wrote: > On 12/20/18 5:51 PM, Chuck Martin wrote: > > Please reply to list also. > Ccing list. > > > > > > > On Thu, Dec 20, 2018 at 7:56 PM Adrian Klaver > > wrote: > > > > On 12/20/18 12:35 PM, Chuck Martin wr

custom installation path for PostgreSQL RPMs ( Relocatable Binaries )

Hi All, I wanted to install the PostgreSQL-11 Software with Custom installation and data directory path. Currently I am using EDB one click installer software with option file like below to achieve, However EDB stopped and no longer provides one click installer for Linux. *Example:* PostgreSQL

RE: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2

Hi Mark, Can you try setting up stats target for school_id column and analyze table and see where it takes, something like: -- ALTER table common_student ALTER COLUMN school_id SET STATISTICS 1; ANALYZE common_stundent; Regards, Virendra From: Mark [mailto:mwchamb...@gmail.com] Sent: Friday

Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2

Hi All, I'm seeing some very slow queries and it looks like the query planner is deciding to do a 'Nested Loop Left Join' which is slow. When I SET enable_nestloop=OFF for testing it does a 'Hash Left Join' which is much faster. I think I can see the cause of the problem in the examples below.

RE: Multiple LDAP Servers for ldap Authentication

Hi Chris, It is better explained if we include an example in the documentation. That will be self explainatory. Regards, Virendra -Original Message- From: Christopher Browne [mailto:cbbro...@gmail.com] Sent: Thursday, December 20, 2018 6:16 PM To: Kumar, Virendra Cc: Alvaro Herre

Re: How to compare dates from two tables with blanks values

thanks for this. I did get it to work using coalesce and nullif on opposite sides of the where condition, but the IS DISTINCT FROM certainly sounds a better approach. Coming from SQLServer until last year , never came across it before Mike On Wed, 19 Dec 2018 at 10:57, Arnaud L. wrote: > Le 19/

Re: Wals not recycling

Yes Ian, it worked..  Many Thanks,Rijo Roy On Friday, 21 December, 2018, 4:16:09 AM IST, Ian Lawrence Barwick wrote: 2018年12月20日(木) 21:58 Rijo Roy : > > Thanks sk for replying Ian.. I have one inactive replication slot in the > database. I suspected that could be the cause but was not