Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViS8Y-0004pA-CS for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:57:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1ViS8X-0004Nb-RF for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:57:21 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViS8W-0004NU-GT for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:57:20 +0000 Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViS8T-0006zN-Hx for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:57:19 +0000 Received: from pps.filterd (pp2.rice.edu [127.0.0.1]) by pp2.rice.edu (8.14.5/8.14.5) with SMTP id rAIGvG09023995; Mon, 18 Nov 2013 10:57:16 -0600 Received: from mh1.mail.rice.edu (mh1.mail.rice.edu [128.42.201.20]) by pp2.rice.edu with ESMTP id 1g61dh8nss-1; Mon, 18 Nov 2013 10:57:15 -0600 X-Virus-Scanned: by amavis-2.7.0 at mh1.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh1.mail.rice.edu (Postfix) with ESMTP id C438B4602C5; Mon, 18 Nov 2013 10:57:15 -0600 (CST) Received: by aart.rice.edu (Postfix, from userid 18612) id BA9AF10033B; Mon, 18 Nov 2013 10:57:15 -0600 (CST) Date: Mon, 18 Nov 2013 10:57:15 -0600 From: "ktm@rice.edu" To: Rogerio Pereira Cc: pgsql-performance@postgresql.org Subject: Re: Query in cache Message-ID: <20131118165715.GM28440@aart.rice.edu> References: <528A4271.80806@riosoft.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <528A4271.80806@riosoft.com.br> User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 kscore.is_bulkscore=0 kscore.compositescore=0 circleOfTrustscore=0 compositescore=0.999264499702524 urlsuspect_oldscore=0.999264499702524 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0 bulkscore=0 kscore.is_spamscore=0 recipient_to_sender_totalscore=0 recipient_domain_to_sender_domain_totalscore=0 rbsscore=0.999264499702524 spamscore=0 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.9 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1305240000 definitions=main-1311180113 X-Pg-Spam-Score: -2.4 (--) 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 On Mon, Nov 18, 2013 at 02:38:09PM -0200, Rogerio Pereira wrote: > Hi, > > I am need help, about 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. > > Regards, > Hi Rogerio, PostgreSQL does not have a query cache. I think you would need to roll your own. Regards, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance