Skip site navigation (1) Skip section navigation (2)

cacheing metadata

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 (view raw or flat)
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


Responses

pgsql-jdbc by date

Next:From: Chris SmithDate: 2004-02-17 13:40:27
Subject: Re: SSL without verifying server certificate
Previous:From: Kris JurkaDate: 2004-02-17 03:35:57
Subject: Re: SSL without verifying server certificate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group