X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 075C5D1DC7C for ; Mon, 15 Mar 2004 22:51:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23350-06 for ; Mon, 15 Mar 2004 18:51:34 -0400 (AST) Received: from commsecure.com.au (CommSecureAustPtyLtd.sb1.optus.net.au [203.202.148.106]) by svr1.postgresql.org (Postfix) with ESMTP id E2043D1DCF1 for ; Mon, 15 Mar 2004 18:50:38 -0400 (AST) Received: from [172.16.15.13] (ws12.commsecure.com.au [172.16.15.13]) by commsecure.com.au (8.11.6/8.11.6) with ESMTP id i2FMloV27922; Tue, 16 Mar 2004 09:47:50 +1100 Subject: Re: Scaling further up From: Stephen Robert Norris To: Matt Davies Cc: pgsql-performance@postgresql.org In-Reply-To: <1079382515.405611f35f1c5@www.mattdavies.net> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098062@vt-pe2550-001.vantage.vantage.com> <20040315200930.GA2921@phlogiston.dyndns.org> <1079382515.405611f35f1c5@www.mattdavies.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-4aDSe6bRa4NC7STN9+JI" Organization: CommSecure Australia Pty Ltd Message-Id: <1079390869.1256.1.camel@ws12.commsecure.com.au> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Tue, 16 Mar 2004 09:47:50 +1100 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/208 X-Sequence-Number: 6064 --=-4aDSe6bRa4NC7STN9+JI Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2004-03-16 at 07:28, Matt Davies wrote: > This is the preferred method, but you could create a memory disk if runni= ng > linux. This has several caveats, though. >=20 > 1. You may have to recompile the kernel for support. > 2. You must store the database on a hard drive partition during reboots. > 3. Because of #2 this option is generally useful if you have static conte= nt that > is loaded to the MD upon startup of the system.=20 And 4. You use twice as much memory - one lot for the FS, the second for buffer cache. It's generally going to be slower than simply doing some typical queries to preload the data into buffer cache, I think. Stephen --=-4aDSe6bRa4NC7STN9+JI Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQBAVjKU4hFS2REFUecRAm1lAJ44t0kEDBmrllTwztxR/UUbt508EQCfd1e3 mHvjrlE4yzXvrkAu9D4ETLE= =wMCo -----END PGP SIGNATURE----- --=-4aDSe6bRa4NC7STN9+JI--