afancy <groupme@xxxxxxxxx> writes: > My PostgreSQL server has two CPUs (OS: Fedora 11), each with 4 cores. Total > is 8cores. Now I have several clients running at the same time to do insert > and update on the same table, each client having its own connection. I have > made two testing with clients running in parallel to load 20M data in > total. Each testing, the data is split evenly by the client number such that > each client only loads a piece of data. What exactly are you doing when you "load data"? There are some code paths that are slower if they have to examine not-yet-committed tuples, and your report sounds a bit like that might be what's happening. But with so few details (not even a Postgres version number :-() it's difficult to be sure of anything. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
