RE: Re: OID Perfomance - Object-Relational databases - Mailing list pgsql-sql

From Michael Ansley
Subject RE: Re: OID Perfomance - Object-Relational databases
Date
Msg-id 7F124BC48D56D411812500D0B747251406145C@fileserver002.intecsystems.co.uk
Whole thread Raw
In response to OID Perfomance - Object-Relational databases  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
<p><font size="2">Given what we've been discussing over the past day or so, can anybody explain this to
me:</font><p><fontsize="2">dev=# explain select client.address.postcode from client;</font><br /><font
size="2">NOTICE: QUERY PLAN:</font><p><font size="2">Seq Scan on client  (cost=0.00..1.01 rows=1
width=4)</font><p><fontsize="2">EXPLAIN</font><br /><font size="2">dev=# select client.address.postcode from
client;</font><br/><font size="2">ERROR:  init_fcache: Cache lookup failed for procedure 18935</font><br /><p><font
size="2">Cheers...</font>

pgsql-sql by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: OID Perfomance - Object-Relational databases
Next
From: Tom Lane
Date:
Subject: Re: Q: performance on some selects (7.0.2)?