| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | cacheing metadata |
| Date: | 2004-02-17 04:28:47 |
| Message-ID: | 1076992127.6799.153.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
There is some interest in caching meta-data. I am wondering what the
community thinks of the idea.
Notionally it would be used to speed up DataBaseMetaData queries. It
will require some work on the backend to create triggers on schema
changes. This is being considered as we speak.
The one challenge is that we don't have non-blocking sockets so we
basically have to do an empty query to see if the cache is dirty and
then reload it if it is
Kris has already commented that this sounds like a fair bit of
complexity for a method that is rarely called.
Dave
--
Dave Cramer
519 939 0336
ICQ # 14675561
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Smith | 2004-02-17 13:40:27 | Re: SSL without verifying server certificate |
| Previous Message | Kris Jurka | 2004-02-17 03:35:57 | Re: SSL without verifying server certificate |