Hi, Jim, Jim Nasby wrote: > Your biggest win would be to batch those inserts together into > transactions, if possible. Using COPY instead of INSERT might even give better wins, and AFAIK some client libs use COPY internally (e. G. tablewriter from libpqxx). > If not, the commit_delay settings might help you out. As far as I understand, this will only help for concurrent inserts by different clients, dealing throughput for latency. Please correct me if I'm wrong. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
