[Postgres-xl-general] Slow insert

web master socketman2016 at gmail.com
Tue Mar 14 04:10:16 PDT 2017


I read this article
https://blog.2ndquadrant.com/improving-performance-for-sequnces-and-serials-in-postgres-xl/

And want to do like that , I set sequence_range TO 1000; and repeat the
following query 40000 times

INSERT INTO sensor_log (location, reading, reading_date)

In the article it take 397.406 ms why for me it take 45 sec? I run
postgres-xl in servers with 512GB ram , 70 core cpu and 1Tb SSD hard

I have 1 cord , 1 gtm proxy , 1 gtm and 2 data node

I see that query executation time is vary from 5ms to 700 ms , why?


I am newbie in postgres-xl , let me know where is my problem?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20170314/12fdd268/attachment.htm>


More information about the postgres-xl-general mailing list