[GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-21 Thread Ilya I. Ashchepkov
Hi, all. I wrote a function and during testing it I came across the strange behaviour. Function runtime is about 200ms first 5 times, 6th and futher calls takes ~22000 ms. I simplified my schema, you can see it in attached file. I've tested on 9.4beta3 and 9.3.5. When I removed security_barrier f

Re: [GENERAL] JSONB spaces in text presentation

2014-09-24 Thread Ilya I. Ashchepkov
ch larger" part is a bit scary. Is this documented somewhere? > > Best regards > Seref > > > On Wed, Sep 24, 2014 at 2:44 PM, Merlin Moncure > wrote: > >> On Wed, Sep 24, 2014 at 2:44 AM, Ilya I. Ashchepkov >> wrote: >> > I'm sorry about send

Re: [GENERAL] JSONB spaces in text presentation

2014-09-24 Thread Ilya I. Ashchepkov
IMHO, prettification is useful only for debugging. It would be nice to have a session variable for the debug output with spaces, new lines and indentation. On Wed, Sep 24, 2014 at 8:44 PM, Merlin Moncure wrote: > On Wed, Sep 24, 2014 at 2:44 AM, Ilya I. Ashchepkov > wrote: > > I&#

Re: [GENERAL] JSONB spaces in text presentation

2014-09-24 Thread Ilya I. Ashchepkov
I'm sorry about sending email several times. I haven't understand, was it sent by gmail or not. On Wed, Sep 24, 2014 at 2:30 PM, John R Pierce wrote: > On 9/24/2014 12:23 AM, Ilya I. Ashchepkov wrote: > >> >> Is spaces is necessary in text presentation of JSONB?

[GENERAL] JSONB spaces in text presentation

2014-09-24 Thread Ilya I. Ashchepkov
Hi. Is spaces is nessesary in text presentation of JSONB? In my data resulting text contains ~12% of spaces. I'm developing web application, and want to get json-string from pg and send it to browser without repacking. -- С уважением, Ащепков Илья koc...@gmail.com

[GENERAL] JSONB spaces in text presentation

2014-09-24 Thread Ilya I. Ashchepkov
Hi. Is spaces is necessary in text presentation of JSONB? In my data resulting text contains ~12% of spaces. I'm developing web application, and want to get json-string from pg and send it to browser without repacking. -- С уважением, Ащепков Илья koc...@gmail.com

[GENERAL] JSONB spaces in text presentation

2014-09-23 Thread Ilya I. Ashchepkov
Hi. Is spaces is nessesary in text presentation of JSONB? In my data resulting text contains ~12% of spaces. I'm developing web application, and want to get json-string from pg and send it to browser without repacking. -- С уважением, Ащепков Илья koc...@gmail.com