Tom, > BTW, what is the actual size of the test database (disk footprint wise) > and how much of that do you think is heavily accessed during the run? > It's possible that the test conditions are such that adjusting > shared_buffers isn't going to mean anything anyway.
The raw data is 32GB, but a lot of the activity is incremental, that is inserts and updates to recent inserts. Still, according to Mark, most of the data does get queried in the course of filling orders. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend