X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2959DD1B45D for ; Thu, 18 Dec 2003 17:05:51 +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 52007-04 for ; Thu, 18 Dec 2003 13:05:01 -0400 (AST) Received: from smtp-slave1.fsdata.se (smtp-gw.fsdata.se [195.35.82.150]) by svr1.postgresql.org (Postfix) with ESMTP id 3CF6FD1B45E for ; Thu, 18 Dec 2003 13:05:00 -0400 (AST) Received: from www3.aname.net (www3.aname.net [62.119.28.103]) by smtp-slave1.fsdata.se (8.12.10/8.12.0) with ESMTP id hBIH4qIY023254 for ; Thu, 18 Dec 2003 18:04:52 +0100 Received: from www3.aname.net (localhost [127.0.0.1]) by www3.aname.net (8.12.10/8.12.10) with ESMTP id hBIH4qgX010135 for ; Thu, 18 Dec 2003 18:04:52 +0100 Received: (from servi008@localhost) by www3.aname.net (8.12.10/8.12.0/Submit) id hBIH4qJj010134; Thu, 18 Dec 2003 18:04:52 +0100 Date: Thu, 18 Dec 2003 18:04:52 +0100 From: Conny Thimren Reply-To: conny.thimren@servit.se Subject: general peformance question To: pgsql-performance@postgresql.org Message-ID: MIME-Version: 1.0 Content-Type: TEXT/plain; CHARSET=iso-8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE Importance: Normal X-Mailer: FS Webmail v2.0 X-FSDATA-AntiSpamScore: 1.8 X-FSDATA-AntiSpamRules: MIME_QP_DEFICIENT X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/285 X-Sequence-Number: 5145 Hi, This a kind of newbie-question. I've been using Postgres for a long time in= a low transction environment - and it is great. Now I've got an inquiry for using Postgresql in a heavy-load on-line system= . This system must handle something like 20 questions per sec with a respon= se time at 1/10 sec. Each question will result in approx 5-6 reads and a co= uple of updates. Anybody have a feeling if this is realistic on a Intelbased Linux server wi= th Postgresql. Ofcourse I know that this is too little info for an exact an= swer but - as I said - maybe someone can give a hint if it's possible. Mayb= e someone with heavy-load can give an example of what is possible... Regards Conny Thimr=E9n