Re: Tuning scenarios (was Changing the default configuration)

Folks,

I forgot one question:

> 2) Ask the user for all of the following data:
> a) How much RAM does your system have?
> b) How many concurrent users, typically?
> c) How often do you run VACUUM/FULL/ANALYZE?
> d) Which of the Five Basic Operations does your database perform
> frequently? (this question could be reduced to "what kind of database do
> you have?" web site database = A and C
> reporting database = A and B
> transaction processing = A, C, D and possibly E etc.)
> e) For each of the 5 operations, how many times per minute is it run?
> f) Do you care about crash recovery? (if not, we can turn off fsync)
> g) (for users testing on their own database) Please make a copy of your
> database, and provide 5 pools of operation examples.
h) (for users using the test database) How large do you expect your main
tables to be in your database? (then the test database would need to have
its tables trimmed to match this estimate)

--
Josh Berkus
Aglio Database Solutions
San Francisco