Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsrxp-00026U-0s for pgsql-sql@arkaria.postgresql.org; Tue, 17 Dec 2013 10:33:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vsrxo-0001hQ-93 for pgsql-sql@arkaria.postgresql.org; Tue, 17 Dec 2013 10:33:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsrxn-0001hJ-9D for pgsql-sql@postgresql.org; Tue, 17 Dec 2013 10:33:19 +0000 Received: from mimolette.dalibo.net ([212.85.154.222]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsrxk-0002z6-GQ for pgsql-sql@postgresql.org; Tue, 17 Dec 2013 10:33:18 +0000 Received: from [192.168.0.38] (ip-68.net-81-220-133.standre.rev.numericable.fr [81.220.133.68]) by mimolette.dalibo.net (Postfix) with ESMTPSA id CCEED6820019; Tue, 17 Dec 2013 11:32:39 +0100 (CET) Message-ID: <52B02826.3030208@dalibo.com> Date: Tue, 17 Dec 2013 11:32:06 +0100 From: Vik Fearing User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: Achilleas Mantzios , pgsql-sql@postgresql.org Subject: Re: Query caching (with 8.3) References: <52AEDCF0.8000606@matrix.gatewaynet.com> <52AF8AE3.6070801@dalibo.com> <52B006B9.6050003@matrix.gatewaynet.com> In-Reply-To: <52B006B9.6050003@matrix.gatewaynet.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On 12/17/2013 09:09 AM, Achilleas Mantzios wrote: > On 17/12/2013 01:21, Vik Fearing wrote: >> On 12/16/2013 11:58 AM, Achilleas Mantzios wrote: >>> postgresql 8.3 (upgrading is not an option for the moment) >> When your version is no longer getting security fixes and data >> corruption fixes, upgrading is not only an option but a duty. >> >> Please upgrade to at least 9.0 (8.4 will be EOL too soon for the effort >> to be worthwhile). >> > > We run several versions of PostgreSQL (on shore and at sea) and if you > search the archives you will see that we are one of the > first to deploy PostgreSQL in a commercial marine environment (since > 2001), and also to develop our own version of DBMirror specifically > tailored for marine/satellite communications, to provide FK-dependency > oriented, row grained, Conditional, Asynchronous, > Lazy replication solution. > Since you mention it, this is installed on about 90 vessels at sea, > and if we assume 3000 EUR (tickets only) for a > trained person to get on board and perform the upgrade, this amounts > to 270,000 EUR. That's nice. How much is the data worth? -- Vik -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql