On 08/21/2016 11:53 PM, Павел Филонов wrote:
My greetings to everybody! I recently faced with the observation which I can not explain. Why insertion throughput can be reduced with an increase of batch size? Brief description of the experiment. * PostgreSQL 9.5.4 as server * https://github.com/sfackler/rust-postgres library as client driver * one relation with two indices (scheme in attach) Experiment steps: * populate DB with 259200000 random records * start insertion for 60 seconds with one client thread and batch size = m * record insertions per second (ips) in clients code Plot median ips from m for m in [2^0, 2^1, ..., 2^15] (in attachment). On figure with can see that from m = 128 to m = 256 throughput have been reduced from 13 000 ips to 5000. I hope someone can help me understand what is the reason for such behavior?
To add to Jeff's questions: You say you are measuring the IPS in the clients code. Where is the client, on the same machine, same network or remote network?
-- Best regards Filonov Pavel
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
