Received: from fileserver002.intecsystems.co.uk ([194.200.14.125]) by hub.org (8.10.1/8.10.1) with ESMTP id e94CvuG69546 for ; Wed, 4 Oct 2000 08:57:56 -0400 (EDT) Received: by fileserver002.intecsystems.co.uk with Internet Mail Service (5.5.2650.21) id <4D5C9DDG>; Wed, 4 Oct 2000 13:59:05 +0100 Message-ID: <7F124BC48D56D411812500D0B747251406145C@fileserver002.intecsystems.co.uk> From: Michael Ansley To: sqllist Subject: RE: Re: OID Perfomance - Object-Relational databases Date: Wed, 4 Oct 2000 13:59:04 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C02E02.DFFB1DC4" X-Archive-Number: 200010/54 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C02E02.DFFB1DC4 Content-Type: text/plain; charset="iso-8859-1" Given what we've been discussing over the past day or so, can anybody explain this to me: dev=# explain select client.address.postcode from client; NOTICE: QUERY PLAN: Seq Scan on client (cost=0.00..1.01 rows=1 width=4) EXPLAIN dev=# select client.address.postcode from client; ERROR: init_fcache: Cache lookup failed for procedure 18935 Cheers... ------_=_NextPart_001_01C02E02.DFFB1DC4 Content-Type: text/html; charset="iso-8859-1" RE: [SQL] Re: OID Perfomance - Object-Relational databases

Given what we've been discussing over the past day or so, can anybody explain this to me:

dev=# explain select client.address.postcode from client;
NOTICE:  QUERY PLAN:

Seq Scan on client  (cost=0.00..1.01 rows=1 width=4)

EXPLAIN
dev=# select client.address.postcode from client;
ERROR:  init_fcache: Cache lookup failed for procedure 18935


Cheers...

------_=_NextPart_001_01C02E02.DFFB1DC4--