Received: from nevald.k-net.dk (IDENT:postfix@nevald.k-net.dtu.dk [130.225.71.226]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA28836 for ; Fri, 2 Jun 2000 14:34:53 -0400 (EDT) (envelope-from Nikolaj@konfus.dk) Received: from carlsberg.kampsax.dtu.dk (carlsberg.kampsax.dtu.dk [192.38.212.2]) by nevald.k-net.dk (Postfix) with SMTP id AD5AB3C48A for ; Fri, 2 Jun 2000 20:34:38 +0200 (CEST) Received: (qmail 31141 invoked from network); 2 Jun 2000 18:34:38 -0000 Received: from commando.kampsax.dtu.dk (HELO commando) (192.38.212.143) by carlsberg.kampsax.dtu.dk with SMTP; 2 Jun 2000 18:34:38 -0000 Message-ID: <000b01bfccc1$53ef2840$8fd426c0@commando.kampsax.dtu.dk> From: "Nikolaj Lundsgaard" To: Subject: Benchmark Date: Fri, 2 Jun 2000 20:35:29 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id OAA28962 X-Archive-Number: 200006/21 Is there anywhere I can find some benchmark test for postgres. The reason is that I want to use it for a site that could have several simultanous users querying the database and I want to be sure that it is stable (and fast) enough to handle that kind of (ab)use. Also which is fastest ? 1. A query (using index of course) for a text in the database. or 2. Reading from a file on the harddisk. If the answer is 1 will the answer still be 1 if I do it several times (100.000+ a day) Regards Nikolaj