The Postgres 10 feature you didn't know about: CREATE STATISTICS


26 bookmarks. First posted by briantrice march 2018.


These statistics allow the planner to estimate how many rows will be returned after executing a certain part of the plan, which then influences the kind of scan or join algorithm which will be used. They are collected / updated mainly by running ANALYZE or VACUUM (and a few DDL commands such as CREATE INDEX ). This doesn’t hold true when columns are correlated or dependant on each other and that leads the planner to under or over-estimate the number of rows which will be returned by these conditions. In actual production schemas, you invariably have certain columns which have dependencies or relationships with each other which the database doesn’t know about. In Citus use cases, we have customers storing billions of rows of data and the implications of bad plans can be drastic.
12 weeks ago by sechilds
If you’ve done some performance tuning with Postgres, you might have used EXPLAIN . EXPLAIN shows you the execution plan that the PostgreSQL planner generates…
from instapaper
march 2018 by adamlogic
Postgres stores a lot of statistics about your data in order to effectively retrieve results when you query your database. Here we deep dive into some of the statistics PostgreSQL stores and how yo...
postgresql  performance 
march 2018 by knokio
If you’ve done some performance tuning with Postgres, you might have used EXPLAIN . EXPLAIN shows you the execution plan that the PostgreSQL planner generates…
from instapaper
march 2018 by joeybaker
Postgres keeps getting better and better

When we set out to build Citus we explicitly chose Postgres as the foundation to build on. By extending Postgres we chose a solid foundation that continues to get better with each release. Because Citus is a pure extension and not a fork all the great new features that come out in each release you get to take advantage of when using Citus.
postgres  statistics 
march 2018 by euler
If you’ve done some performance tuning with Postgres, you might have used EXPLAIN . EXPLAIN shows you the execution plan that the PostgreSQL planner generates…
from instapaper
march 2018 by stingh711
RT : The Postgres 10 feature you didn't know about: CREATE STATISTICS
from twitter
march 2018 by jamesog
The Postgres 10 feature you didn't know about: CREATE STATISTICS
databases  from twitter_favs
march 2018 by briantrice