Re: Caching of Queries - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: Caching of Queries
Date
Msg-id opsjhp2pricq72hf@musicbox
Whole thread Raw
In response to Re: Caching of Queries  (Gaetano Mendola <mendola@bigfoot.com>)
List 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).

pgsql-performance by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Using LIMIT changes index used by planner
Next
From: "Amrit Angsusingh"
Date:
Subject: Howto Increased performace ?