Message-ID: <53F70F8F.5030406@lab.ntt.co.jp>
Date: Fri, 22 Aug 2014 18:38:23 +0900
From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
User-Agent: Mozilla/5.0 (Windows NT 6.0;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@2ndquadrant.com>, Noah Misch <noah@leadboat.com>
CC: shigeru.hanada@gmail.com,
 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>,
 pgsql-hackers@postgresql.org
Subject: Re: inherit support for foreign tables
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>
In-Reply-To: <20140822035858.GJ6343@eldon.alvh.no-ip.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

(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