X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7F1D4475C45 for ; Fri, 21 Feb 2003 03:44:33 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 50184-08 for ; Fri, 21 Feb 2003 03:44:22 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id 4F8C547592C for ; Fri, 21 Feb 2003 03:41:45 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h1L8fj425011 for ; Fri, 21 Feb 2003 14:11:45 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h1L8fjt25006 for ; Fri, 21 Feb 2003 14:11:45 +0530 From: "Shridhar Daithankar" To: Date: Fri, 21 Feb 2003 14:12:25 +0530 MIME-Version: 1.0 Subject: Re: performance issues for processing more then 150000 records / day. Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3E5633C9.27527.439F17A@localhost> In-reply-to: <007c01c2d983$f3d60d70$0900000a@new> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/146 X-Sequence-Number: 1202 On 21 Feb 2003 at 10:33, Jakab Laszlo wrote: > > Hello Chris, > > I mean here 150000 inserts/day ( quickly grows constantly )... - with > transactions and on the same table ... maybe after onesignificant amount of > time we can move the records of one year to one archivetable ... > Andsome 2-3 millions of selects / day ... > > I would like to know also some hardware related advice. Use a 64 bit machine with SCSI, preferrably RAID to start with. You can search list archives for similar problems and solutions. HTH Bye Shridhar -- Fog Lamps, n.: Excessively (often obnoxiously) bright lamps mounted on the fronts of automobiles; used on dry, clear nights to indicate that the driver's brain is in a fog. See also "Idiot Lights".