Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViZIp-0004Jc-Jl for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 00:36:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1ViZIo-00006j-Ru for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 00:36:26 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViZIn-00006Y-JQ for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 00:36:25 +0000 Received: from nm18-vm0.bullet.mail.ne1.yahoo.com ([98.138.91.37]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViZIj-00079h-Lm for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 00:36:23 +0000 Received: from [98.138.100.113] by nm18.bullet.mail.ne1.yahoo.com with NNFMP; 19 Nov 2013 00:36:20 -0000 Received: from [98.138.101.169] by tm104.bullet.mail.ne1.yahoo.com with NNFMP; 19 Nov 2013 00:36:20 -0000 Received: from [127.0.0.1] by omp1080.mail.ne1.yahoo.com with NNFMP; 19 Nov 2013 00:36:20 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 703473.72149.bm@omp1080.mail.ne1.yahoo.com Received: (qmail 64455 invoked by uid 60001); 19 Nov 2013 00:36:20 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1384821380; bh=ks4lhTJ8HwEJDltq80C+FcOZN1NdHhCGAuvla2xMKTU=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=4iZIYhQoUGZ05s8F6aJzKyji9xn/wrLLpLgo+4q0ofWXm5XDHWf/otCq4BeZLCUexCOibWRox4GMupEzm6wGzd2UlPty5sQciYqGMkLhcI6o5rt1SNLwvs6RG4NJTb4vnbCzU4NNmTyktnnkE8SnI6uN7t5g5fHTeqtkXzeVTHk= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=YbII3uONssGsAIddHWZGcfoYTle3w4vIU1hKAQaUWCvHiH1WIsOO1Wm2TMFcfWrlakBwQEwWRdke3P5JBkH4ZE5WujuqArozs+tvaHd0sGy1YzJKTOv7bjQ2aGVuTqQEfGrIsQ4lry3Q9cMrhR+rsVf040epi5sxvhTryecxBq0=; X-YMail-OSG: _P6RImoVM1kHlhMKWLeKz13sR71PTwFLweChheJYBeVb9qF PsagU.tjXrXQT_MSXTDtUtU5bzejXomkf4iPmGMNGIohMJRQbX2eSQbeaYkD 7c9a318Z9hnBUkfJ3XqnsgwkQwLr9R3yhxc4uLNfZZTEK16AZaCe5EzyLl8I 3ZO.83rcKOBOORc4oPNtiLAi9U61pCeIVJr3g9FoPwY_4A8NBH12r2tkqtoO 6KvdQ62fxxazfRbh.XplGvSYZRmdim7hT77_8Sn_uBQ0LxnZR3Kh6hIexTIe Ws58v3B2TeQOQFMhwZ65oKyfx1SgOsdifm8sWpLd2juf9d.o99V58Jr9zH74 k7aMXHqFJoHZh9H9.pOsMwWnmi807mif_4G3Pv8.ouq0STh4xDy3j09N8djX P3vHgl97wXW.S40whybRDkWF1IqyA2X7nQcCgpmyecIBlrLIGX4owD3jqsNr LdCiD2K90CyYAFLty51tLv2Lq7W_pA6szZBHRV1kLjm43ZE675I198qaa9_W lQS0XVbal_Xp1inQmydkM.Cm52PS91QKjMlU__51BtQUBazDjgI8lA8sm8Nw Nevuqy3fqvEgLN3NZDQp.1N0E31vTBgANOg5oatk- Received: from [93.194.241.169] by web122202.mail.ne1.yahoo.com via HTTP; Mon, 18 Nov 2013 16:36:20 PST X-Rocket-MIMEInfo: 002.001, SGVsbG8sCgpwZ3Bvb2wgc3VwcG9ydHMgbWVtY2FjaGUuClJlZ2FyZHMKCgoKCk9uIE1vbmRheSwgTm92ZW1iZXIgMTgsIDIwMTMgNjoyOSBQTSwgQW5kcmVhcyBLcmV0c2NobWVyIDxha3JldHNjaG1lckBzcGFtZmVuY2UubmV0PiB3cm90ZToKIApSb2dlcmlvIFBlcmVpcmEgPHJvZ2VyaW8ucGVyZWlyYUByaW9zb2Z0LmNvbS5icj4gd3JvdGU6CgoKPiBIaSwKPgo.IEkgYW0gbmVlZCBoZWxwLCBhYm91dCBzdWJqZWN0ICJRdWVyeSBjYWNoZSBpbsKgIFBvc3RncmVzIi4KPiBob3cgaXMgaXQgcG9zc2libGUgdG8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.166.601 References: <528A4271.80806@riosoft.com.br> <20131118164355.GA27277@tux> Message-ID: <1384821380.63647.YahooMailNeo@web122202.mail.ne1.yahoo.com> Date: Mon, 18 Nov 2013 16:36:20 -0800 (PST) From: salah jubeh Reply-To: salah jubeh Subject: Re: Query in cache To: Andreas Kretschmer , "pgsql-performance@postgresql.org" In-Reply-To: <20131118164355.GA27277@tux> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="251260810-2142066884-1384821380=:63647" X-Pg-Spam-Score: 0.2 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --251260810-2142066884-1384821380=:63647 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello,=0A=0Apgpool supports memcache.=0ARegards=0A=0A=0A=0A=0AOn Monday, No= vember 18, 2013 6:29 PM, Andreas Kretschmer wro= te:=0A =0ARogerio Pereira wrote:=0A=0A=0A>= Hi,=0A>=0A> I am need help, about subject "Query cache in=A0 Postgres".=0A= > how is it possible to put sql statements cached in postgres ?=0A> I did s= ome tests and I can not get even with improved tuning=0A> parameters in the= postgresql.conf.=0A=0ANo, there isn't something like a query cache. But yo= u can use=0Amaterialized views, since 9.3.=0A=0A=0AAndreas=0A-- =0AReally, = I'm not out to destroy Microsoft. That will just be a completely=0Aunintent= ional side effect.=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 (Linus Torvalds)=0A"If I was god, I would recompile penguin with --enab= le-fly."=A0 (unknown)=0AKaufbach, Saxony, Germany, Europe.=A0 =A0 =A0 =A0 = =A0 =A0 =A0 N 51.05082=B0, E 13.56889=B0=0A=0A=0A-- =0ASent via pgsql-perfo= rmance mailing list (pgsql-performance@postgresql.org)=0ATo make changes to= your subscription:=0Ahttp://www.postgresql.org/mailpref/pgsql-performance --251260810-2142066884-1384821380=:63647 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hello,
pgpool supports memcache.
Regards


On Monday, November 18, 2013 6:29 PM, And= reas Kretschmer <akretschmer@spamfence.net> wrote:
=
Rogerio Pereira <rogerio.pereira@riosoft.com.br> wrote:


= > Hi,
>
> I am need help, abou= t subject "Query cache in  Postgres".
> how is it= possible to put sql statements cached in postgres ?
>= I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.


No, there isn't something like a query cache. But you can use<= br clear=3D"none">materialized views, since 9.3.


Andreas
--
Really, I'm= not out to destroy Microsoft. That will just be a completely
unintentional side effect.            &n= bsp;                 (Linus Torvald= s)
"If I was god, I would recompile penguin with --enable= -fly."  (unknown)
Kaufbach, Saxony, Germany, Europe= .              N 51.05082=B0, E 13.56889= =B0


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


--251260810-2142066884-1384821380=:63647--