| From: | Sean Chittenden <sean-pgsql-general(at)chittenden(dot)org> |
|---|---|
| To: | Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Statement handle caching... |
| Date: | 2001-04-05 09:02:39 |
| Message-ID: | 20010405020239.Q8827@rand.tgd.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In practice this is a question surrounding DBI, but:
if you make a query and send it to postgres, it gets
optimized. The resulting query tree, is it cached at all? Is it
accessable through a statement handle? Does postgres have a query
cache manager that caches frequently used queries so I don't have to
worry about this?
Anyway, caching optimized queries (or query trees): is this a
feature? If not, why? If so, where did I miss reading this (thought
I read every scrap of printed material that wasn't in the mailing
list, but still searched and read a fair bit of mailing list material
too)? -sc
--
Sean Chittenden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Velkov | 2001-04-05 09:13:33 | copy from multi-line text problem |
| Previous Message | Oliver Elphick | 2001-04-05 08:59:07 | Almost all access to database hangs (fwd) |