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 E5D9CD1B550 for ; Tue, 12 Aug 2003 18:27:54 +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 00656-02 for ; Tue, 12 Aug 2003 15:26:18 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [64.117.225.209]) by svr1.postgresql.org (Postfix) with ESMTP id 4307DD1F4D7 for ; Tue, 12 Aug 2003 15:25:37 -0300 (ADT) Received: from beth.coza.net.za (beth.coza.net.za [206.223.136.193]) by www.postgresql.com (Postfix) with ESMTP id A3C29CF7B62 for ; Tue, 12 Aug 2003 04:17:40 -0300 (ADT) Received: from coza.net.za (mixo.coza.net.za [206.223.136.225]) by beth.coza.net.za (8.11.6/8.11.2) with ESMTP id h7C7GOo02922; Tue, 12 Aug 2003 09:16:28 +0200 Message-ID: <3F389449.8050305@coza.net.za> Date: Tue, 12 Aug 2003 09:16:25 +0200 From: mixo Reply-To: mixo@coza.net.za User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3b) Gecko/20030811 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bjoern Metzdorf Cc: pgsql-performance@postgresql.org Subject: Re: Perfomance Tuning References: <3F337B39.5030904@coza.net.za> <01ed01c35d99$73f08d70$0564a8c0@shock> In-Reply-To: <01ed01c35d99$73f08d70$0564a8c0@shock> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/213 X-Sequence-Number: 3030 Thanks to everyone who responded. It's a pity that the discussion has gone the ext2 vs ext3 route. The main reason I asked my original question is that I am currently importing data into Pg which is about 2.9 Gigs. Unfortunately, to maintain data intergrity, data is inserted into a table one row at a time. This exercise took ~7 days on the same system with slightly different setup(PIII 1.0GHZ, 512M RAM -- CPU speed was down graded due to serveral over heating problems which have since been fixed, and RAM was added for good measure). I have just reloaded the machine, and started the import. So far ~ 6000 record have been imported, and there is 32000 left. P.S. Importing the same data on Mysql took ~2 days. Bjoern Metzdorf wrote: >>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. >> >> > >For 15 users you won't need great tuning at all. Just make sure, that you >have the right indizes on the tables and that you have good queries (query >plan). > >About the 8Meg blobs, I don't know. Other people on this list may be able to >give you hints here. > >Regards, >Bjoern > >