"Kevin Grittner" <kevin.gritt...@wicourts.gov> writes: > The checkpoint_segments seems dramatic enough to be real. I wonder if > the test is short enough that it never got around to re-using any of > them, so it was doing extra writes for the initial creation during the > test?
That's exactly what I was about to suggest. Are you starting each run from a fresh initdb? If so, try running the load long enough that the number of WAL files stabilizes (should happen at 2x checkpoint_segments) and then start the test measurement. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers