RE: Re: OID Perfomance - Object-Relational databases

From: Michael Ansley <Michael(dot)Ansley(at)intec-telecom-systems(dot)com>
To: sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: RE: Re: OID Perfomance - Object-Relational databases
Date: 2000-10-04 12:59:04
Message-ID: 7F124BC48D56D411812500D0B747251406145C@fileserver002.intecsystems.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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...

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-10-04 15:22:11 Re: Q: performance on some selects (7.0.2)?
Previous Message Jeff MacDonald 2000-10-04 11:43:46 Re: OID Perfomance - Object-Relational databases