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. > A credible alternative is to emit a second message indicating that we > skipped the inheritance tree statistics after all, and why we skipped > them. That'd be similar to Xorg emitting messages such as [ 53.772] (II) intel(0): RandR 1.2 enabled, ignore the following RandR disabled message. [ 53.800] (--) RandR disabled I find this very poor. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers