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 697E0D1B442 for ; Thu, 18 Dec 2003 19:42:09 +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 68591-08 for ; Thu, 18 Dec 2003 15:41:20 -0400 (AST) Received: from smtp4.hy.skanova.net (smtp4.hy.skanova.net [195.67.199.133]) by svr1.postgresql.org (Postfix) with ESMTP id 62E3FD1B444 for ; Thu, 18 Dec 2003 15:41:02 -0400 (AST) Received: from Foo (h224n2fls35o962.telia.com [217.211.189.224]) by smtp4.hy.skanova.net (8.12.10/8.12.10) with SMTP id hBIJegr5012844 for ; Thu, 18 Dec 2003 20:40:42 +0100 (CET) Message-ID: <004901c3c59f$365de160$6400a8c0@telia.com> From: "Conny Thimren" To: Subject: general performance question Date: Thu, 18 Dec 2003 20:43:29 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0046_01C3C5A7.97E6C700" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4920.2300 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=HTML_10_20 X-Spam-Level: * X-Archive-Number: 200312/287 X-Sequence-Number: 5147 This is a multi-part message in MIME format. ------=_NextPart_000_0046_01C3C5A7.97E6C700 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 This a kind of newbie-question. I've been using Postgres for a long time in= a low transction environment - and it is great.=20 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.=20 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...=20 Regards=20 Conny Thimr=E9n=20 ------=_NextPart_000_0046_01C3C5A7.97E6C700 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi= ,
This a=20 kind of newbie-question. I've been using Postgres for a long time in a low= =20 transction environment - and it is great.

Now I've got an inquiry f= or=20 using Postgresql in a heavy-load on-line system. This system must handle=20 something like 20 questions per sec with a response time at 1/10 sec. Each= =20 question will result in approx 5-6 reads and a couple of updates.
Anybo= dy=20 have a feeling if this is realistic on a Intelbased Linux server with=20 Postgresql. Ofcourse I know that this is too little info for an exact answe= r but=20 - as I said - maybe someone can give a hint if it's possible. Maybe someone= with=20 heavy-load can give an example of what is possible...

Regards
C= onny=20 Thimr=E9n


------=_NextPart_000_0046_01C3C5A7.97E6C700--