Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsqeu-0007kN-9x for pgsql-sql@arkaria.postgresql.org; Tue, 17 Dec 2013 09:09:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vsqet-0003g9-Pp for pgsql-sql@arkaria.postgresql.org; Tue, 17 Dec 2013 09:09:43 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsqet-0003g3-2X for pgsql-sql@postgresql.org; Tue, 17 Dec 2013 09:09:43 +0000 Received: from adsltrust.ath.forthnet.gr ([194.219.204.174] helo=smadev.internal.net) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsqel-0005zF-FV for pgsql-sql@postgresql.org; Tue, 17 Dec 2013 09:09:42 +0000 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.14.7/8.14.7) with ESMTP id rBH89T3m054649; Tue, 17 Dec 2013 10:09:29 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Message-ID: <52B006B9.6050003@matrix.gatewaynet.com> Date: Tue, 17 Dec 2013 10:09:29 +0200 From: Achilleas Mantzios User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:24.0) Gecko/20100101 Thunderbird/24.0.1 MIME-Version: 1.0 To: Vik Fearing , pgsql-sql@postgresql.org Subject: Re: Query caching (with 8.3) References: <52AEDCF0.8000606@matrix.gatewaynet.com> <52AF8AE3.6070801@dalibo.com> In-Reply-To: <52AF8AE3.6070801@dalibo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.8 (/) 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 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. -- Achilleas Mantzios -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql