pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: Tuning scenarios (was Changing the default configuration)
Date: Fri, 14 Feb 2003 10:10:00 -0800
Message-ID: <200302141010.00403.josh@agliodbs.com> (raw)
In-Reply-To: <200302140936.02011.josh@agliodbs.com>
References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local>
	<20030214114843.GB1847@filer>
	<200302140936.02011.josh@agliodbs.com>

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



view thread (10+ messages)  latest in thread

Message-ID: <200302141010.00403.josh@agliodbs.com>
Permalink:  ../200302141010.00403.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200302141010.00403.josh@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com
  Subject: Re: Tuning scenarios (was Changing the default configuration)
  In-Reply-To: <200302141010.00403.josh@agliodbs.com>
  References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <20030214114843.GB1847@filer> <200302140936.02011.josh@agliodbs.com> <200302141010.00403.josh@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox