Re: Out of Memory

2018-09-29 Thread Peter J. Holzer
On 2018-09-28 07:23:59 +0200, Laurenz Albe wrote: > Rob Sargent wrote: > > > Christoph Moench-Tegeder wrote: > > > > ## Laurenz Albe (laurenz.a...@cybertec.at): > > > > > > > > > vm.overcommit_memory = 2 > > > > > vm_overcommit_ratio = 100 > > > > > > > > > > Linux commits (swap *

Re: ORM

2018-09-29 Thread marcelo
On 28/09/2018 21:39 , Adrian Klaver wrote: On 9/28/18 3:49 PM, marcelo wrote: For a new big and convoluted project I (am/was) using Devart´s LinqConnect as ORM. But today I experienced some inexplicable "object reference not set to an instance of an object" exceptions or other more specific

Re: How to maintain the csv log files in pg_log directory only for past 30 days

2018-09-29 Thread Adrian Klaver
On 9/28/18 7:05 PM, Raghavendra Rao J S V wrote: Hi All, Hope you all are recommending below settings to maintain only max 30 days logs in *pg_log* directory. Please correct me if I am wrong. Well it would actually be 31 days as:

[proposal] pg_stat_statements: extension timing instrumentation

2018-09-29 Thread legrand legrand
Don't you have been surprised by the duration of a query (seen in psql with \timing) and the duration for the same query found in pgss ? It seems that writting the first query text to file takes some time, that high execution rate on the same query could generate waits on locks as when pgss is

Re: Why my query not using index to sort?

2018-09-29 Thread Arup Rakshit
Hello Adrian, I used to consider this time as the sql execution time approximately. I’ll do some research and get back to you. Thanks for mentioning it. Thanks, Arup Rakshit a...@zeit.io > On 29-Sep-2018, at 2:50 AM, Adrian Klaver wrote: > > On 9/28/18 12:14 PM, Arup Rakshit wrote: >>

Re: ORM

2018-09-29 Thread Adrian Klaver
On 9/29/18 6:47 AM, marcelo wrote: On 28/09/2018 21:39 , Adrian Klaver wrote: On 9/28/18 3:49 PM, marcelo wrote: For a new big and convoluted project I (am/was) using Devart´s LinqConnect as ORM. But today I experienced some inexplicable "object reference not set to an instance of an

Re: ORM

2018-09-29 Thread Dmitry Igrishin
сб, 29 сент. 2018 г. в 1:50, marcelo : > > For a new big and convoluted project I (am/was) using Devart´s > LinqConnect as ORM. > But today I experienced some inexplicable "object reference not set to > an instance of an object" exceptions or other more specific to this > libraries. > I would wish

Re: ORM

2018-09-29 Thread marcelo
On 29/09/2018 16:09 , Edson Carlos Ericksson Richter wrote: Em 28/09/2018 19:49, marcelo escreveu: For a new big and convoluted project I (am/was) using Devart´s LinqConnect as ORM. But today I experienced some inexplicable "object reference not set to an instance of an object" exceptions

Re: Why my query not using index to sort?

2018-09-29 Thread Arup Rakshit
Hello Tom, I have another query, where I am expecting the sort from index, but it is in memory and takes lot of time. Query: explain analyze select * from "standard_workitems" where "standard_workitems"."deleted_at" is null and "standard_workitems"."company_id"

Re: Why my query not using index to sort?

2018-09-29 Thread Arup Rakshit
When I keep the sort off, I see it is executing much more faster. set enable_sort = off; explain analyze select * from "standard_workitems" where "standard_workitems"."deleted_at" is null and "standard_workitems"."company_id" =

Re: Postgres trigger side-effect is occurring out of order with row-level security select policy

2018-09-29 Thread Adrian Klaver
On 9/28/18 11:35 PM, Carl Sverre wrote: *Context* I am using row-level security along with triggers to implement a pure SQL RBAC implementation. While doing so I encountered a weird behavior between INSERT triggers and SELECT row-level security policies. *Question* I have posted a very

Re: ORM

2018-09-29 Thread Edson Carlos Ericksson Richter
Em 28/09/2018 19:49, marcelo escreveu: For a new big and convoluted project I (am/was) using Devart´s LinqConnect as ORM. But today I experienced some inexplicable "object reference not set to an instance of an object" exceptions or other more specific to this libraries. I would wish to