Received: from serlin.ivsol ([148.233.222.76]) by hub.org (8.10.1/8.10.1) with ESMTP id e7KM0Hm27601 for ; Sun, 20 Aug 2000 18:00:17 -0400 (EDT) Received: from fralet (fralet.ivsol [192.168.1.11]) by serlin.ivsol (8.9.3/8.8.7) with SMTP id QAA00881; Sun, 20 Aug 2000 16:46:19 -0500 Message-ID: <002701c00af0$995531a0$0b01a8c0@ivsol> From: "Franz J Fortuny" To: "The Hermit Hacker" Cc: "pgSQL" References: Subject: RE: Speed or configuration Date: Sun, 20 Aug 2000 16:50:04 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200008/198 "First question(s) I have is what version of PostgreSQL? what hardware is the commercial SQL server running on? PostgreSQL? memory, cpu, hard drives, etc?" Version: postgresql-7.0.2-2.i386.rpm Hardware: Same Hardware for all SQL Servers (same machine, of course, one SQL Server is idle while the other one is active). Memory: 512 MB RAM, 16GB Hard disk. Pentium II (old) I am glad to hear that it's possible to get such good results. I always thought there would be a way. I'll try this query you have suggested... Franz J Fortuny