From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Neil Conway" <nconway(at)klamath(dot)dyndns(dot)org> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: experimental pg_qcache patch |
Date: | 2002-04-14 05:04:50 |
Message-ID: | 013501c1e371$e855ef00$0200a8c0@SOL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Just explicitly prepared ones. Caching all queries opens a can of
> worms that I'd rather not deal with at the moment (volunteers to
> tackle this problem are welcome).
I definitely agree. I think that the optimisation possiblities offered to
the DBA for shared prepared statements are quite large enough to offer
exciting possibilities. Also, it will minimise the locking contentions Tom
speaks of.
> > Does is check for cached queries all the time or just explicitly
EXECUTED
> > ones?
>
> A cached query plan is only used for EXECUTE queries -- it is
> not used all the time. My gut feeling WRT to caching everything
> is similar to my response to your first question.
It'll be interesting to have VIEWs automatically prepared and executed from
the cache...
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-04-14 05:20:38 | Re: experimental pg_qcache patch |
Previous Message | Bruce Momjian | 2002-04-14 05:02:59 | Re: [PATCHES] WITH DELIMITERS in COPY |