Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsw2r-0002Qm-DD for pgsql-sql@arkaria.postgresql.org; Tue, 17 Dec 2013 14:54:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vsw2q-0000HA-P3 for pgsql-sql@arkaria.postgresql.org; Tue, 17 Dec 2013 14:54:48 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vsw2q-0000H4-2N for pgsql-sql@postgresql.org; Tue, 17 Dec 2013 14:54:48 +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 1Vsw2n-0003jW-Aa for pgsql-sql@postgresql.org; Tue, 17 Dec 2013 14:54:47 +0000 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.14.7/8.14.7) with ESMTP id rBHEshI9079859 for ; Tue, 17 Dec 2013 16:54:43 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Message-ID: <52B065B3.3080603@matrix.gatewaynet.com> Date: Tue, 17 Dec 2013 16:54:43 +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: 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> In-Reply-To: <52B02826.3030208@dalibo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.0 (/) 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 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. -- 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