Search: [Statistics] - Anayrat links

How PostgreSQL improved statistics collector in the latest version

PostgreSQL · pg16 · Statistics

April 20, 2023 at 11:19:43 AM GMT+2 * · permalink

https://www.postgresql.fastware.com/blog/how-postgresql-improved-statistics-collector-in-the-latest-version

PostgreSQL 16: More I/O statistics

PostgreSQL · pg16 · Statistics · pg_stat_io

February 14, 2023 at 11:06:44 AM GMT+1 * · permalink

https://www.dbi-services.com/blog/postgresql-16-more-i-o-statistics/

Improving GROUP BY with CREATE STATISTICS - CYBERTEC

PostgreSQL · Statistics

January 11, 2023 at 11:36:40 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/improving-group-by-with-create-statistics/

Postgres Indexes, Selectivity, and Statistics

PostgreSQL · Statistics

July 19, 2022 at 4:08:31 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/indexes-selectivity-and-statistics

Queries in PostgreSQL: 2. Statistics : Postgres Professional

PostgreSQL · Statistics

March 11, 2022 at 7:04:45 PM GMT+1 * · permalink

https://postgrespro.com/blog/pgsql/5969296

Queries in PostgreSQL. Statistics / Habr

PostgreSQL · Statistics

February 28, 2022 at 8:33:00 PM GMT+1 * · permalink

https://habr.com/en/company/postgrespro/blog/652971/

GitHub - influxdata/tdigest: An implementation of Ted Dunning's t-digest in Go.

Percentile computation

Publication · Statistics · tdigest

December 9, 2019 at 11:12:00 AM GMT+1 * · permalink

https://github.com/influxdata/tdigest

Linear Interpolation with PostgreSQL

SQL · PostgreSQL · Statistics

June 15, 2019 at 11:58:17 AM GMT+2 * · permalink

https://bytefish.de/blog/postgresql_interpolation/

Debugging the Postgres query planner — GoCardless Blog

PostgreSQL · planner · Statistics

March 4, 2019 at 4:17:06 PM GMT+1 * · permalink

https://gocardless.com/blog/debugging-the-postgres-query-planner/

Lies, damned lies, and statistics

PostgreSQL · Statistics

December 28, 2018 at 12:35:22 PM GMT+1 * · permalink

https://www.pgcon.org/2017/schedule/attachments/443_lies-damned-lies-and-statistics.pdf

PostgreSQL query planner’s internals

PostgreSQL · planner · Statistics · Tricks

December 4, 2018 at 3:13:38 PM GMT+1 * · permalink

https://pgday.ru/presentation/170/59648e053f0f0.pdf

Beyond EXPLAIN - Query Optimization From Theory To Code

PostgreSQL · Statistics

November 23, 2018 at 11:21:59 AM GMT+1 * · permalink

https://www.pgcon.org/2016/schedule/attachments/433_PGCON2016_beyond_explain.pdf

AUTO PLAN TUNING USING FEEDBACK LOOP

PostgreSQL · planner · Statistics · pg_plan_advsr

November 19, 2018 at 4:12:50 PM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2132/slides/143/PGConfEU2018_auto_plan_tuning_by_Tatsuro_Yamada.pdf

create-statistics-talk/create-statistics-what-is-it.pdf at master · tvondra/create-statistics-talk · GitHub

PostgreSQL · Statistics

March 19, 2018 at 1:14:04 PM GMT+1 * · permalink

https://github.com/tvondra/create-statistics-talk/blob/master/create-statistics-what-is-it.pdf

Using pg_badplan to CREATE STATISTICS is a good plan | Joel on SQL

PostgreSQL · Statistics · pg_badplan · extension

March 19, 2018 at 1:10:40 PM GMT+1 * · permalink

https://joelonsql.com/2018/03/19/using-pg_badplan-to-create-statistics-is-a-good-plan/

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

PostgreSQL · Statistics

March 8, 2018 at 4:15:46 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2018/03/06/postgres-planner-and-its-usage-of-statistics/

GitHub - ossc-db/pg_dbms_stats: Let PostgreSQL to make execution plans using frozen statistics.

pg_dbms_stats · PostgreSQL · Statistics

February 5, 2018 at 9:59:47 AM GMT+1 * · permalink

https://github.com/ossc-db/pg_dbms_stats

Data Egret: Deep dive into Postgres stats: pg_stat_progress_vacuum

PostgreSQL · pg_stat_progress_vacuum · Statistics

November 1, 2017 at 9:26:03 PM GMT+1 * · permalink

http://blog.postgresql-consulting.com/2017/10/deep-dive-into-postgres-stats_31.html

Bruce Momjian: Future Optimizer Enhancements

PostgreSQL · Statistics

September 13, 2017 at 8:23:24 PM GMT+2 * · permalink

https://momjian.us/main/blogs/pgblog/2017.html#September_13_2017

ORACLE-BASE - Optimizer Statistics Advisor in Oracle Database 12c Release 2 (12.2)

Oracle · Statistics

August 27, 2017 at 3:10:58 PM GMT+2 * · permalink

https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2