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 0D9B552A48 for ; Sat, 26 Mar 2005 01:31:58 +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 30043-08 for ; Sat, 26 Mar 2005 01:31:49 +0000 (GMT) Received: from mail.tecarta.com (66.238.115.135.ptr.us.xo.net [66.238.115.135]) by svr1.postgresql.org (Postfix) with ESMTP id 48598533E3 for ; Sat, 26 Mar 2005 01:31:48 +0000 (GMT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Fri, 25 Mar 2005 17:34:47 -0800 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Fri, 25 Mar 2005 17:34:43 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005032517344314778 for ; Fri, 25 Mar 2005 17:34:43 -0800 X-ASG-Debug-ID: 1111800708-6378-1-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail2 (mail2.hq.corp [192.168.160.6]) by barracuda.tecarta.com (Spam Firewall) with SMTP id 836672003DD6 for ; Fri, 25 Mar 2005 17:31:48 -0800 (PST) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Fri, 25 Mar 2005 17:34:40 -0800 Message-ID: <4244483B.8020401@sfnet.cc> Date: Fri, 25 Mar 2005 17:19:55 +0000 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: performance pgsql X-ASG-Orig-Subj: Re: [PERFORM] How to improve db performance with $7K? Subject: Re: How to improve db performance with $7K? References: <42443863.4040302@sfnet.cc> <20356.1111798757@sss.pgh.pa.us> In-Reply-To: <20356.1111798757@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 26 Mar 2005 01:34:40.0583 (UTC) FILETIME=[FAB9AD70:01C531A3] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: 0.84 X-Barracuda-Spam-Status: No, SCORE=0.84 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_44, DATE_IN_PAST_06_12 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.2139 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -0.00 BAYES_44 BODY: Bayesian spam probability is 44 to 50% [score: 0.4977] 0.85 DATE_IN_PAST_06_12 Date: is 6 to 12 hours before Received: date X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.816 tagged_above=0 required=5 tests=AWL, DATE_IN_PAST_06_12, FORGED_RCVD_HELO, NO_DNS_FOR_FROM X-Spam-Level: X-Archive-Number: 200503/579 X-Sequence-Number: 11284 Tom, From what I understand, the vendor used ProIV for development, when they attempted to use 7.4.3, they had ODBC issues and something else I honestly don't know, but I was told that data was not coming through properly. Their somewhat at the mercy of the ProIV people to give them the stamp of approval, then the vendor will tell us what they support. Thanks. Steve Poe Tom Lane wrote: >Steve Poe writes: > > >>Situation: An 24/7 animal hospital (100 employees) runs their business >>on Centos 3.3 (RHEL 3) Postgres 7.4.2 (because they have to) >> >> > >[ itch... ] Surely they could at least move to 7.4.7 without pain. >There are serious data-loss bugs known in 7.4.2. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > >