X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E9A1ED1C4D0 for ; Wed, 30 Jul 2003 17:20:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 71813-10 for ; Wed, 30 Jul 2003 14:19:23 -0300 (ADT) Received: from davinci.ethosmedia.com (209-128-84-228.bayarea.net [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id E3499D1C4B7 for ; Wed, 30 Jul 2003 14:20:23 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3360937; Wed, 30 Jul 2003 10:20:43 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "scott.marlowe" , Subject: Re: postgresql.conf Date: Wed, 30 Jul 2003 10:19:21 -0700 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200307301019.21870.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/482 X-Sequence-Number: 2775 Scott, > I'm guessing OLTP needs things like FSM cranked up,=20 > OLAP (a for analytical) needs more shared buffers and sort memory > Webserver might be better served just slightly higher values than default= =20 > but well under those of either OLTP or OLAP... Yes. Take sort_mem for example: OLTP_SM 1024 OLTP_LM 2048 OLAP_SM 4096 OLAP_LM 16384 WWW_SM 512 WWW_LM 1024 Workstation 1024 The basic idea is: More RAM =3D> more sort_mem More concurrent queries =3D> less sort_mem Larger data sets =3D> more sort_mem Lots of grouped aggregates =3D> more sort_mem --=20 -Josh Berkus Aglio Database Solutions San Francisco