[PERFORM] V8 optimisation (if you're using javascript in postgres)

https://medium.com/@c2c/nodejs-a-quick-optimization-advice-7353b820c92e 100% performance boost, for mysterious reasons that may be worth knowing about… Graeme Bell -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription:

Re: [PERFORM] Having some problems with concurrent COPY commands

On 10/12/2015 11:14 PM, Shaun Thomas wrote: On Mon, Oct 12, 2015 at 1:28 PM, Andres Freund wrote: Any chance you could provide profiles of such a run? This is as simple as I could make it reliably. With one copy running, the thread finishes in about 1 second. With 2,

Re: [PERFORM] Having some problems with concurrent COPY commands

On Tue, Oct 13, 2015 at 2:32 AM, Heikki Linnakangas wrote: > 80% of the CPU time is spent in the b-tree comparison function. In the logs, my duration per COPY command increases from about 1400ms for one process to about 3800ms when I have four running concurrently. That's really

Re: [PERFORM] Having some problems with concurrent COPY commands

On 2015-10-13 07:14:01 -0700, Shaun Thomas wrote: > On Tue, Oct 13, 2015 at 2:32 AM, Heikki Linnakangas wrote: > > 80% of the CPU time is spent in the b-tree comparison function. > > In the logs, my duration per COPY command increases from about 1400ms > for one process to about

Re: [PERFORM] Having some problems with concurrent COPY commands

On Tue, Oct 13, 2015 at 7:23 AM, Andres Freund wrote: > and send the results. Whelp, I'm an idiot. I can't account for how I did it, but I can only assume I didn't export my ports in the tests properly. I ran everything again and there's a marked difference between 9.3 and

Re: [PERFORM] Having some problems with concurrent COPY commands

On 14 October 2015 at 08:33, Shaun Thomas wrote: > On Tue, Oct 13, 2015 at 7:23 AM, Andres Freund wrote: > > and send the results. > > Whelp, I'm an idiot. I can't account for how I did it, but I can only > assume I didn't export my ports in the tests