Re: [PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-26 Thread Soni M
Changing to a higher rate CPU would be more helpful if you run less than 32 queries at a time. On Tue, Aug 26, 2014 at 8:51 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Monday, August 25, 2014, Jeison Bedoya Delgado jeis...@audifarma.com.co wrote: hi, recently i change the hardware of my

Re: [PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-26 Thread Mark Kirkwood
On 26/08/14 06:47, Jeison Bedoya Delgado wrote: hi, recently i change the hardware of my database 32 cores up to 64 cores and 128GB Ram, but the performance is the same. Perhaps i have to change any parameter in the postgresql.conf?. In addition to the points that others have made, even if

Re: [PERFORM] autocommit (true/false) for more than 1 million records

2014-08-26 Thread Alex Goncharov
On the COPY's atomicity -- looking for a definitive answer from a core developer, not a user's guess, please. Suppose I COPY a huge amount of data, e.g. 100 records. My 99 records are fine for the target, and the 100-th is not -- it comes with a wrong record format or a target constraint

Re: [PERFORM] autocommit (true/false) for more than 1 million records

2014-08-26 Thread Kevin Grittner
Alex Goncharov alex.goncharov@gmail.com wrote: Suppose I COPY a huge amount of data, e.g. 100 records. My 99 records are fine for the target, and the 100-th is not -- it comes with a wrong record format or a target constraint violation. The whole thing is aborted then, and the good 99

Re: [PERFORM] autocommit (true/false) for more than 1 million records

2014-08-26 Thread Alex Goncharov
Thank you, Kevin -- this is helpful. But it still leaves questions for me. Kevin Grittner kgri...@ymail.com wrote: Alex Goncharov alex.goncharov@gmail.com wrote: The whole thing is aborted then, and the good 99 records are not making it into the target table. Right. This is one

Re: [PERFORM] autocommit (true/false) for more than 1 million records

2014-08-26 Thread David G Johnston
On Tue, Aug 26, 2014 at 9:21 PM, Alex Goncharov-2 [via PostgreSQL] ml-node+s1045698n5816426...@n5.nabble.com wrote: Thank you, Kevin -- this is helpful. But it still leaves questions for me. Kevin Grittner [hidden email] http://user/SendEmail.jtp?type=nodenode=5816426i=0 wrote: Alex

Re: [PERFORM] Turn off Hyperthreading! WAS: 60 core performance with 9.3

2014-08-26 Thread Mark Kirkwood
On 26/08/14 10:13, Josh Berkus wrote: On 08/22/2014 07:02 AM, Andres Freund wrote: On 2014-08-21 14:02:26 -0700, Josh Berkus wrote: On 08/20/2014 07:40 PM, Bruce Momjian wrote: Not sure how you can make such a blanket statement when so many people have tested and shown the benefits of

Re: [PERFORM] autocommit (true/false) for more than 1 million records

2014-08-26 Thread Alex Goncharov
Thank you, Kevin -- this is helpful. Thank you David, too. But it still leaves questions for me. Still... Alex Goncharov alex.goncharov@gmail.com wrote: How do I decide, before starting a COPY data load, whether such a load protection (complexity) makes sense (is necessary)? This is