| Lists: | pgsql-hackers |
|---|
| From: | Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Finding relfilenode |
| Date: | 2014-04-24 13:59:57 |
| Message-ID: | CAFUsPDaC5ZcPr5JpKRs1NFqLmb1Wn8zE4bLZO54rvSLvm42UzQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Finding relfilenode |
| Date: | 2014-04-24 14:27:12 |
| Message-ID: | 30301.1398349632@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)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