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 5B78AD1C990 for ; Fri, 8 Aug 2003 16:40:37 +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 44789-09 for ; Fri, 8 Aug 2003 13:39:09 -0300 (ADT) Received: from irko.smoothcorp.com (unknown [208.49.241.41]) by svr1.postgresql.org (Postfix) with ESMTP id 58E59D1C4DB for ; Fri, 8 Aug 2003 13:40:26 -0300 (ADT) Received: from [10.0.1.63] (helo=jgardner.smoothcorp.com) by irko.smoothcorp.com with esmtp (Exim 4.12) id 19lAHx-0005Yt-00; Fri, 08 Aug 2003 09:40:25 -0700 Received: from jgardner.smoothcorp.com (localhost.localdomain [127.0.0.1]) by jgardner.smoothcorp.com (8.12.8/8.12.8) with ESMTP id h78GePsN027676; Fri, 8 Aug 2003 09:40:25 -0700 Received: from localhost (localhost [[UNIX: localhost]]) by jgardner.smoothcorp.com (8.12.8/8.12.8/Submit) id h78GeL8l027670; Fri, 8 Aug 2003 09:40:21 -0700 From: Jonathan Gardner To: mixo , pgsql-performance@postgresql.org Subject: Re: Perfomance Tuning Date: Fri, 8 Aug 2003 09:40:20 -0700 User-Agent: KMail/1.5 References: <3F337B39.5030904@coza.net.za> In-Reply-To: <3F337B39.5030904@coza.net.za> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200308080940.21517.jgardner@jonathangardner.net> X-SA-Exim-Rcpt-To: mixo@coza.net.za, pgsql-performance@postgresql.org X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/153 X-Sequence-Number: 2970 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday 08 August 2003 03:28, mixo wrote: > I have just installed redhat linux 9 which ships with Pg > 7.3.2. Pg has to be setup so that data inserts (blobs) should > be able to handle at least 8M at a time. The machine has > two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and > a 36 Gig hd with 1 Gig swap and 3 equal size ext3 partitions. > What would be the recomended setup for good performance > considering that the db will have about 15 users for > 9 hours in a day, and about 10 or so users throughout the day > who wont be conistenly using the db. > Redhat puts ext3 on by default. Consider switching to a non-journaling FS= =20 (ext2?) with the partition that holds your data and WAL. Consider having a seperate partition for the WAL as well. These are things that are more difficult to change later on. Everything els= e=20 is tweaking. Is it absolutely necessary to store 8MB files in the database? I find it=20 cumbersome. Storing them on a file server has been a better alternative for= =20 me. - --=20 Jonathan Gardner Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/M9J0WgwF3QvpWNwRAlT5AJ9EmDourbCiqj7MFOqfBospc2dW7gCfZKz0 JQjn/2KAeh1SPJfN601LoFg=3D =3DPW6k -----END PGP SIGNATURE-----