Re: Caching of Queries

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Caching of Queries
Date: 2004-12-24 02:19:27
Message-ID: opsjhp2pricq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>> 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).

You don't use persistent connections ???????????
Your problem might simply be the connection time overhead (also including
a few TCP roudtrips).

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Clark 2004-12-24 14:52:11 Re: Speed in V8.0
Previous Message Pierre-Frédéric Caillaud 2004-12-24 02:05:59 Re: Using LIMIT changes index used by planner