Greg Smith <g...@2ndquadrant.com> wrote: > If, say, your stats say there's 2B rows in the table but there's > actually 2.5B, that's a big error, but unlikely to change the > types of plans you get. Once there's millions of distinct values > it's takes a big change for plans to shift, etc. Well, the exception to that is if the stats say that your highest value is x, and there are actually 500 million rows with values greater than x, you can get some very bad plans for queries requiring a range of values above x. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
