Re: Improving PostgreSQL insert performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux