Re: Refresh materialized view deadlocking?

2018-07-10 Thread Akshaya Acharya
Hi Xiao From https://www.postgresql.org/docs/current/static/sql-refreshmaterializedview.html For concurrently option " Even with this option only one REFRESH at a time may run against any one materialized view. " I would guess yes. Regards, Akshaya On Tue, 10 Jul 2018 at 23:24, Xiao Ba wrote:

Re: Too many range table entries error

2018-06-27 Thread Akshaya Acharya
, Tom Lane wrote: > Andres Freund writes: > > On 2018-06-25 13:46:06 +0530, Akshaya Acharya wrote: > >> Our entire application-all our business logic-is built as layers of > views > >> inside the database. The ref counts sort of multiple at each layer, > hence >

Re: Too many range table entries error

2018-06-25 Thread Akshaya Acharya
On Mon, 25 Jun 2018 at 13:40, Andres Freund wrote: > Hi, > > On 2018-06-25 13:02:37 +0530, Akshaya Acharya wrote: > > Hello. > > > > > > Please could you help debug the error "too many range table entries”? > > > > > > This error occ

Too many range table entries error

2018-06-25 Thread Akshaya Acharya
Hello. Please could you help debug the error "too many range table entries”? This error occurs when querying a view that is dependent on many other views (i.e. a view high up in the pyramid of views that we've constructed). I get this error when running select * on the view, or when running a