Message-ID: <52B099EE.2020408@archidevsys.co.nz>
Date: Wed, 18 Dec 2013 07:37:34 +1300
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
Organization: ArchiDevSys
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 <achill@matrix.gatewaynet.com>,
 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>
 <52B02826.3030208@dalibo.com> <52B065B3.3080603@matrix.gatewaynet.com>
In-Reply-To: <52B065B3.3080603@matrix.gatewaynet.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 18/12/13 03:54, Achilleas Mantzios wrote:
> On 17/12/2013 12:32, Vik Fearing wrote:
>> 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).
>>>>
>>> That's nice. How much is the data worth? 
>
> I think we have deviated from the subject. For the interested reader, 
> the path we took is to
> materialize the query and update it over-night.
>
I think you are dodging the last question, which is a very important hint.

It looks like you are totally ignoring the "security fixes and data 
corruption fixes" that have been added in subsequent versions of PostgreSQL.

If your data is as important as it appears to be, then even a million 
Euro, is not too much to cough up.

What would be the impact of of data corruption, or an attack by a 
criminal gang (or possible more likely, a government agency)?  Note that 
sometimes data corruption can go undetected for a long time.


Cheers,
Gavin


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql