PostgreSQL Internals & Planner
约 1 分钟阅读
Query Planner
Statistics
Join Methods
- Nested Loop: Fast for small data sets or when using indexes on the inner table.
- Hash Join: Most common for larger sets. Hash table built in memory.
- Merge Join: Efficient for large, pre-sorted data sets.
Scan Methods
- Seq Scan: Sequential table scan.
- Index Scan: Lookup via B-Tree/Hash etc.
- Bitmap Scan: Combine index results (BitmapAnd/Or) before visiting heap.
Resources
关联信息
反向链接、本文链接的其他页面和外部资料。
参考资料
其他外链5 条
- momjian.us/main/presentationsmomjian.us/main/presentations
- www.percona.com/blog/2018/08/10/tuning-autovacuum-in-postgresql-and-autovacuum-internalswww.percona.com/blog/2018/08/10/tuning-autovacuum-in-postgresql-and-autovacuum-internals
- www.postgresql.org/docs/current/planner-stats.htmlwww.postgresql.org/docs/current/planner-stats.html
- www.postgresql.org/docs/current/sql-createstatistics.htmlwww.postgresql.org/docs/current/sql-createstatistics.html
- youtu.be/svqQzYFBPIoyoutu.be/svqQzYFBPIo