[Postgres-xl-general] Slow insert
socketman2016 at gmail.com
Tue Mar 14 04:10:16 PDT 2017
I read this article
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...
More information about the postgres-xl-general