Re: Caching of Queries - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Caching of Queries
Date
Msg-id 20040923194626.708b7bce@kingfisher.intern.logi-track.com
Whole thread Raw
In response to Re: Caching of Queries  ("Jason Coene" <jcoene@gotfrag.com>)
List pgsql-performance
Hi, Jason,

On Thu, 23 Sep 2004 12:53:25 -0400
"Jason Coene" <jcoene@gotfrag.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@logi-track.com | www.logi-track.com

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Caching of Queries
Next
From: "Anjan Dave"
Date:
Subject: Re: SAN performance