Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id ADB3F475914 for ; Sun, 18 Aug 2002 01:04:32 -0400 (EDT) Received: from mail.dealnews.com (deadpool.dealnews.com [64.124.135.168]) by postgresql.org (Postfix) with SMTP id 1C5F9475902 for ; Sun, 18 Aug 2002 01:04:32 -0400 (EDT) Received: (qmail 18726 invoked from network); 18 Aug 2002 05:04:31 -0000 Received: from unknown (HELO doughboy) (127.0.0.1) by localhost with SMTP; 18 Aug 2002 05:04:31 -0000 Message-ID: <014001c24674$bfced8b0$0100a8c0@doughboy> From: "Brian Moon" To: "Christopher Kings-Lynne" , , References: <00d001c24665$85dc3e40$0100a8c0@doughboy> <008101c2466d$e5a28c50$0200a8c0@SOL> Subject: Re: PostgreSQL with Phorum Date: Sun, 18 Aug 2002 00:04:36 -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 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/63 X-Sequence-Number: 1408 | I don't have much time, but I'm happy to look at schemas and index | optimisation for you, etc. Has Phorum removed its silly requirement of | creating two whole entire tables per forum yet? With Phorum 5 we have changed that. We had our reasons at the time for doing that. However, things have changed and we are wiser and the tools are better. This kind of gets back to my point. For small to moderately sized Phorums on slower machines, having seperate tables is a good thing in MySQL. We now know that large Phorums suffer in this case worse than the smaller ones would suffer from one table. However, this could very well have never been a good thing for PostgreSQL. I don't really know. At the time I ported Phorum over to PostgreSQL, the docs were not nearly as good as they are now. There was nothing about optimizing your tables for speed. This is the reason I am coming here. I want Phorum 5 to run as fast as it can on PostgreSQL. Thanks, Brian. Phorum Dev Team