Finding relfilenode

Started by Soroosh Sardariover 11 years ago2 messages
#1Soroosh Sardari
soroosh.sardari@gmail.com

Hi

In cost functions such as cost_seqscan, a RelOptinfo indicate a base
relation.
But there is no relfilenode in the RelOptinfo, So how could i find
relfilenode or reloid of the relation?

Thanks,
Soroosh Sardari

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Soroosh Sardari (#1)
Re: Finding relfilenode

Soroosh Sardari <soroosh.sardari@gmail.com> writes:

In cost functions such as cost_seqscan, a RelOptinfo indicate a base
relation.
But there is no relfilenode in the RelOptinfo, So how could i find
relfilenode or reloid of the relation?

You could get the table OID out of the associated RTE. But I fail to
see what value the relfilenode would have at plan time.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers