From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Noah Misch <noah@leadboat.com>
Cc: shigeru.hanada@gmail.com, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org
Subject: Re: inherit support for foreign tables
Date: Fri, 22 Aug 2014 18:38:23 +0900
Message-ID: <53F70F8F.5030406@lab.ntt.co.jp> (raw)
In-Reply-To: <20140822035858.GJ6343@eldon.alvh.no-ip.org>
References: <53393E18.3080901@lab.ntt.co.jp>
<533C01C7.6030809@lab.ntt.co.jp>
<53706FB6.6000403@lab.ntt.co.jp>
<20140620.170406.123403564.horiguchi.kyotaro@lab.ntt.co.jp>
<20140702022327.GC1586927@tornado.leadboat.com>
<53F48245.6020204@lab.ntt.co.jp>
<20140822025137.GA563733@tornado.leadboat.com>
<20140822035858.GJ6343@eldon.alvh.no-ip.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: fujita.etsuro@lab.ntt.co.jp, alvherre@2ndquadrant.com, noah@leadboat.com, horiguchi.kyotaro@lab.ntt.co.jp
Subject: Re: inherit support for foreign tables
In-Reply-To: <53F70F8F.5030406@lab.ntt.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox