Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D4F689FB9D5 for ; Wed, 16 May 2007 00:55:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 85404-03 for ; Wed, 16 May 2007 00:55:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id DD5179FB74C for ; Wed, 16 May 2007 00:55:30 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id l4G3tWKP021665 for ; Tue, 15 May 2007 23:55:32 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id l4G3tWAR021662 for ; Tue, 15 May 2007 23:55:32 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 15 May 2007 23:55:32 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: pgsql-performance@postgresql.org Subject: New performance documentation released Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/282 X-Sequence-Number: 24672 I've been taking notes on what people ask about on this list, mixed that up with work I've been doing lately, and wrote some documentation readers of this mailing list may find useful. There are a series of articles now at http://www.westnet.com/~gsmith/content/postgresql/ about performance testing and tuning. The "5-minute Introduction to PostgreSQL Performance" and the "Disk performance testing" articles were aimed to be FAQ-style pieces people asking questions here might be pointed toward. All of the pieces in the "Advanced Topics" sections aren't finished to my standards yet, but may be useful anyway so I've posted what I've got so far. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD