X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EE0E352965 for ; Thu, 7 Jul 2005 22:33:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47651-02 for ; Fri, 8 Jul 2005 01:32:56 +0000 (GMT) Received: from mail.iinet.net.au (mail-08.iinet.net.au [203.59.3.40]) by svr1.postgresql.org (Postfix) with SMTP id 55DBD52A08 for ; Thu, 7 Jul 2005 22:32:54 -0300 (ADT) Received: (qmail 19059 invoked from network); 8 Jul 2005 01:32:51 -0000 Received: from unknown (HELO localhost.localdomain) (203.217.37.199) by mail.iinet.net.au with SMTP; 8 Jul 2005 01:32:51 -0000 Received: from [127.0.0.1] (localhost.localdomain [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id 6349D14359; Fri, 8 Jul 2005 11:32:46 +1000 (EST) Message-ID: <42CDD7B8.6050109@stuartbishop.net> Date: Fri, 08 Jul 2005 11:32:40 +1000 From: Stuart Bishop User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Mount database on RAM disk? X-Enigmail-Version: 0.90.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigEBFE01B41C91D1AD1C2DFB6D" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.137 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/80 X-Sequence-Number: 13321 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigEBFE01B41C91D1AD1C2DFB6D Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I'm putting together a road map on how our systems can scale as our load increases. As part of this, I need to look into setting up some fast read only mirrors of our database. We should have more than enough RAM to fit everything into memory. I would like to find out if I could expect better performance by mounting the database from a RAM disk, or if I would be better off keeping that RAM free and increasing the effective_cache_size appropriately. I'd also be interested in knowing if this is dependant on whether I am running 7.4, 8.0 or 8.1. -- Stuart Bishop http://www.stuartbishop.net/ --------------enigEBFE01B41C91D1AD1C2DFB6D Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFCzde9AfqZj7rGN0oRAi34AJ9PMD44LBvppopJLYz+BL19HWGb+wCgkmsO g0oTZpwKfU+yRowWeExNv+w= =3Du5 -----END PGP SIGNATURE----- --------------enigEBFE01B41C91D1AD1C2DFB6D--