Unix Technical Forum

pgPool query cache

This is a discussion on pgPool query cache within the Pgsql Performance forums, part of the PostgreSQL category; --> Hi, all. I want to ask, if anyone used query_cache of pgPool. The problem is there is no detailed ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-02-2008, 06:07 AM
Rauan Maemirov
 
Posts: n/a
Default pgPool query cache

Hi, all.

I want to ask, if anyone used query_cache of pgPool. The problem is
there is no detailed installation steps on how to configure it
correctly. Itried to follow it, but guess that it doesn't cache my
queries. So, maybe someone adviced me or give link.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-05-2008, 06:53 AM
Rauan Maemirov
 
Posts: n/a
Default Re: pgPool query cache

On May 1, 7:02*pm, Rauan Maemirov <rauan1...@gmail.com> wrote:
> Hi, all.
>
> I want to ask, if anyone used query_cache of pgPool. The problem is
> there is no detailed installation steps on how to configure it
> correctly. Itried to follow it, but guess that it doesn't cache my
> queries. So, maybe someone adviced me or give link.


Nobody use??
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 05-05-2008, 06:53 AM
Hannes Dorbath
 
Posts: n/a
Default Re: pgPool query cache

Rauan Maemirov wrote:
>> I want to ask, if anyone used query_cache of pgPool. The problem is
>> there is no detailed installation steps on how to configure it
>> correctly. Itried to follow it, but guess that it doesn't cache my
>> queries. So, maybe someone adviced me or give link.

>
> Nobody use??


I'd say caching is better done on a higher level -- like HTML fragments
or what ever you generate from those queries..

Just my two cent.


--
Best regards,
Hannes Dorbath
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 05-05-2008, 06:53 AM
Rauan Maemirov
 
Posts: n/a
Default Re: pgPool query cache

On May 4, 5:13*pm, Hannes Dorbath <li...@theendofthetunnel.de> wrote:
> Rauan Maemirov wrote:
> >> I want to ask, if anyone used query_cache of pgPool. The problem is
> >> there is no detailed installation steps on how to configure it
> >> correctly. Itried to follow it, but guess that it doesn't cache my
> >> queries. So, maybe someone adviced me or give link.

>
> > Nobody use??

>
> I'd say caching is better done on a higher level -- like HTML fragments
> or what ever you generate from those queries..
>
> Just my two cent.
>
> --
> Best regards,
> Hannes Dorbath


Yeah, I know it. But sometimes, if U have a lot of little queries it's
too complicated to cache all of them in code. It simplier to cache
them on database level.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com