agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Gavin Flower <GavinFlower@archidevsys.co.nz>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-sql@postgresql.org
Subject: Re: Query caching (with 8.3)
Date: Wed, 18 Dec 2013 07:37:34 +1300
Message-ID: <52B099EE.2020408@archidevsys.co.nz> (raw)
In-Reply-To: <52B065B3.3080603@matrix.gatewaynet.com>
References: <52AEDCF0.8000606@matrix.gatewaynet.com>
<52AF8AE3.6070801@dalibo.com>
<52B006B9.6050003@matrix.gatewaynet.com>
<52B02826.3030208@dalibo.com>
<52B065B3.3080603@matrix.gatewaynet.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
view thread (8+ messages) latest in thread
Message-ID: <52B099EE.2020408@archidevsys.co.nz>
Permalink: ../52B099EE.2020408@archidevsys.co.nz/
Also on: postgresql.org/message-id/52B099EE.2020408@archidevsys.co.nz
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: GavinFlower@archidevsys.co.nz, achill@matrix.gatewaynet.com
Subject: Re: Query caching (with 8.3)
In-Reply-To: <52B099EE.2020408@archidevsys.co.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox