| From: | Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Noah Misch <noah(at)leadboat(dot)com> |
| Cc: | shigeru(dot)hanada(at)gmail(dot)com, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: inherit support for foreign tables |
| Date: | 2014-08-22 09:38:23 |
| Message-ID: | 53F70F8F.5030406@lab.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
(2014/08/22 12:58), Alvaro Herrera wrote:
> Noah Misch wrote:
>
>> I'm anticipating a bug report along these lines:
>>
>> I saw poor estimates involving a child foreign table, so I ran "ANALYZE
>> VERBOSE", which reported 'INFO: analyzing "public.parent" inheritance
>> tree'. Estimates remained poor, so I scratched my head for awhile before
>> noticing that pg_stats didn't report such statistics. I then ran "ANALYZE
>> VERBOSE parent", saw the same 'INFO: analyzing "public.parent" inheritance
>> tree', but this time saw relevant rows in pg_stats. The message doesn't
>> reflect the actual behavior.
>>
>> I'll sympathize with that complaint.
>
> Agreed on that.
I've got the point. Will fix.
Thanks for the comment!
Best regards,
Etsuro Fujita
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajeev rastogi | 2014-08-22 10:14:36 | Re: Support for N synchronous standby servers |
| Previous Message | Dave Page | 2014-08-22 09:11:06 | Re: Are postgresql-9.4 binaries available on Windows XP? |