X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 410753A4297 for ; Wed, 24 Nov 2004 15:57:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27829-09 for ; Wed, 24 Nov 2004 15:57:36 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 2E6133A4211 for ; Wed, 24 Nov 2004 15:57:39 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id iAOFvIaW018341; Wed, 24 Nov 2004 07:57:18 -0800 Message-ID: <41A4AF4C.60404@commandprompt.com> Date: Wed, 24 Nov 2004 07:57:00 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Evilio del Rio Cc: dspam-users@networkdweebs.com, pgsql-performance@postgresql.org Subject: Re: Postgres vs. MySQL References: <1101302058.338.74.camel@haddock.cmima.csic.es> In-Reply-To: <1101302058.338.74.camel@haddock.cmima.csic.es> Content-Type: multipart/mixed; boundary="------------020407090801000804040300" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/381 X-Sequence-Number: 9335 This is a multi-part message in MIME format. --------------020407090801000804040300 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Evilio del Rio wrote: >Hi, > >I have installed the dspam filter >(http://www.nuclearelephant.com/projects/dspam) on our mail server >(RedHat 7.3 Linux with sendmail 8.13 and procmail). I have ~300 users >with a quite low traffic of 4000 messages/day. So it's a quite common >platform/environment, nothing spectacular. > > > The problem is definately dspam. We have been through their code. The new version is much, much better than the older one but I am sure there is more work to be done. The first version we installed suffered from a well known problem: It would use smallint/bigint but would not cast or quote the where clauses and thus PostgreSQL would never use the indexes. It was also missing several indexes on appropriate columns. We offered some advice and we know that some of it was taken but we don't know which. Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------020407090801000804040300 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------020407090801000804040300--