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
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
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
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
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
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
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
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