X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0D212474E61 for ; Fri, 14 Feb 2003 13:10:31 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 6C3F5474E5C for ; Fri, 14 Feb 2003 13:10:30 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2840264 for pgsql-performance@postgresql.org; Fri, 14 Feb 2003 10:10:36 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: Tuning scenarios (was Changing the default configuration) Date: Fri, 14 Feb 2003 10:10:00 -0800 User-Agent: KMail/1.4.3 References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <20030214114843.GB1847@filer> <200302140936.02011.josh@agliodbs.com> In-Reply-To: <200302140936.02011.josh@agliodbs.com> MIME-Version: 1.0 Message-Id: <200302141010.00403.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/86 X-Sequence-Number: 1142 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 =3D A and C > reporting database =3D A and B > transaction processing =3D 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= =20 tables to be in your database? (then the test database would need to have= =20 its tables trimmed to match this estimate) --=20 Josh Berkus Aglio Database Solutions San Francisco