Re: Caching of Queries

From: Pierre-Frédéric Caillaud
Subject: Re: Caching of Queries
Date: ,
Msg-id: opsjhp2pricq72hf@musicbox
(view: Whole thread, Raw)
In response to: Re: Caching of Queries  (Gaetano Mendola)
List: pgsql-performance

Tree view

Caching of Queries  (Scott Kirkwood, )
 Re: Caching of Queries  (Tom Lane, )
  Re: Caching of Queries  (Neil Conway, )
   Re: Caching of Queries  (Gaetano Mendola, )
  Re: Caching of Queries  ("Gary Doades", )
 Re: Caching of Queries  (Harald Fuchs, )
 Re: Caching of Queries  (Mr Pink, )
  Re: Caching of Queries  ("Jason Coene", )
   Re: Caching of Queries  (Tom Lane, )
    Re: Caching of Queries  ("Jason Coene", )
     Re: Caching of Queries  (Tom Lane, )
      Re: Caching of Queries  (Josh Berkus, )
       Re: Caching of Queries  (Tom Lane, )
     Re: Caching of Queries  (Gaetano Mendola, )
      Re: Caching of Queries  ("Jason Coene", )
       Re: Caching of Queries  ("Jason Coene", )
       Re: Caching of Queries  ("Josh Berkus", )
        Re: Caching of Queries  ("Joshua D. Drake", )
         Re: Caching of Queries  (Gaetano Mendola, )
        Re: Caching of Queries (now with pgpool)  ("Jason Coene", )
         Re: Caching of Queries (now with pgpool)  (Michael Adler, )
          Re: Caching of Queries (now with pgpool)  (Gaetano Mendola, )
   Re: Caching of Queries  (Gaetano Mendola, )
    Re: Caching of Queries  (Pierre-Frédéric Caillaud<>, )
   Re: Caching of Queries  (Greg Stark, )
   Re: Caching of Queries  ("Matt Clark", )
   Re: Caching of Queries  (Markus Schaber, )
  Re: Caching of Queries  ("Jim C. Nasby", )
 Re: Caching of Queries  (<>, )
 Re: Caching of Queries  ("Aaron Werman", )
  Re: Caching of Queries  (Neil Conway, )
   Re: Caching of Queries  (Tom Lane, )
    Re: Caching of Queries  (Mitch Pirtle, )
     Re: Caching of Queries  (Jeff, )
    Re: Caching of Queries  ("Matthew Nuzum", )
   Re: Caching of Queries  (Greg Stark, )
   Re: Caching of Queries  (Scott Kirkwood, )
    Re: Caching of Queries  (Bruce Momjian, )
 Re: Caching of Queries  (Harald Fuchs, )
 Re: Caching of Queries  ("Aaron Werman", )
  Re: Caching of Queries  ("Matt Clark", )
   Re: Caching of Queries  (Rod Taylor, )
    Re: Caching of Queries  (Matt Clark, )
     Re: Caching of Queries  (Rod Taylor, )
      Re: Caching of Queries  (Matt Clark, )
       Re: Caching of Queries  (Tatsuo Ishii, )
        Re: Caching of Queries  ("Matt Clark", )
         Re: Caching of Queries  (Tatsuo Ishii, )
          Re: Caching of Queries  (Tom Lane, )
           Re: Caching of Queries  (Tatsuo Ishii, )
            Re: Caching of Queries  (Bruce Momjian, )
     Re: Caching of Queries  ("Jim C. Nasby", )
      Re: Caching of Queries  (Matt Clark, )
       Re: Caching of Queries  ("Jim C. Nasby", )
        Re: Caching of Queries  ("Matt Clark", )
       Re: Caching of Queries  (Josh Berkus, )
        Re: Caching of Queries  (Pierre-Frédéric Caillaud<>, )
        Re: Caching of Queries  ("Jim C. Nasby", )
      Re: Caching of Queries  (Pierre-Frédéric Caillaud<>, )
   Re: Caching of Queries  (Mitch Pirtle, )
    Re: Caching of Queries  (Matt Clark, )
     Re: Caching of Queries  (Steve Atkins, )
      Re: Caching of Queries  (Matt Clark, )
   Re: Caching of Queries  ("Aaron Werman", )
    Re: Caching of Queries  (Josh Berkus, )
     Re: Caching of Queries  (William Yu, )
      Re: Caching of Queries  (Josh Berkus, )
      Re: Caching of Queries  (Pierre-Frédéric Caillaud<>, )
 Re: Caching of Queries  ("Iain", )
  Re: Caching of Queries  (Tom Lane, )
 Re: Caching of Queries  ("Iain", )
 Re: Caching of Queries  ("Aaron Werman", )
  Re: Caching of Queries  (Tom Lane, )
 Re: Caching of Queries  ("Aaron Werman", )
 Re: Caching of Queries  ("Aaron Werman", )

>> 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:

From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Caching of Queries
From: "Amrit Angsusingh"
Date:
Subject: Howto Increased performace ?