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
