Skip site navigation (1) Skip section navigation (2)

Re: Caching of Queries

From: Markus Schaber <schabios(at)logi-track(dot)com>
To: "Jason Coene" <jcoene(at)gotfrag(dot)com>
Cc: "'Mr Pink'" <mr_pink_is_the_only_pro(at)yahoo(dot)com>,"'Scott Kirkwood'" <scottakirkwood(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Caching of Queries
Date: 2004-09-23 17:46:26
Message-ID: 20040923194626.708b7bce@kingfisher.intern.logi-track.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi, Jason,

On Thu, 23 Sep 2004 12:53:25 -0400
"Jason Coene" <jcoene(at)gotfrag(dot)com> wrote:

> I've looked at PREPARE, but apparently it only lasts per-session - that's
> worthless in our case (web based service, one connection per data-requiring
> connection).

This sounds like the loads of connection init and close may be the
reason for the slowdown. Can you use connection pooling in your service?

HTH,
Markus


-- 
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com

In response to

pgsql-performance by date

Next:From: Anjan DaveDate: 2004-09-23 18:05:05
Subject: Re: SAN performance
Previous:From: Gaetano MendolaDate: 2004-09-23 17:40:32
Subject: Re: Caching of Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group