Skip site navigation (1) Skip section navigation (2)

Re: Tuning scenarios (was Changing the default configuration)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning scenarios (was Changing the default configuration)
Date: 2003-02-14 18:10:00
Message-ID: 200302141010.00403.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
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

In response to

pgsql-performance by date

Next:From: SLetovskyDate: 2003-02-14 19:07:49
Subject: Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE
Previous:From: Josh BerkusDate: 2003-02-14 17:36:02
Subject: Re: Tuning scenarios (was Changing the default configuration)

pgsql-hackers by date

Next:From: Greg StarkDate: 2003-02-14 18:16:26
Subject: Re: location of the configuration files
Previous:From: Kevin BrownDate: 2003-02-14 18:09:37
Subject: Re: location of the configuration files

pgsql-advocacy by date

Next:From: Tilo SchwarzDate: 2003-02-14 21:55:51
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]
Previous:From: Josh BerkusDate: 2003-02-14 17:36:02
Subject: Re: Tuning scenarios (was Changing the default configuration)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group