Re: Improving PostgreSQL insert performance

From: Frits Jalvingh <jal(at)etc(dot)to>
To: "Chellappa, Babu" <Babu_Chellappa(at)unigroup(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Improving PostgreSQL insert performance
Date: 2017-06-09 15:05:13
Message-ID: CAKhTGFW2xJ9cmRSge3rMpVzBK73_oWSPWQrqF-TYeCtuTKGXjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Babu,

No, I did not, and the effect is quite great:

Inserted 1000000 rows in 2535 milliseconds, 394477.3175542406 rows per
second
Inserted 1000000 rows in 2553 milliseconds, 391696.0438699569 rows per
second

compared to (without your parameter):
Inserted 1000000 rows in 7643 milliseconds, 130838.67591259976 rows per
second

That is quite an increase!! Thanks a lot for the tip!!

For those keeping score: we're now at 77% of Oracle's performance- without
copy ;)

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John Gorman 2017-06-09 15:08:45 Re: Improving PostgreSQL insert performance
Previous Message Frits Jalvingh 2017-06-09 14:57:58 Re: Improving PostgreSQL insert performance