To check the distribution of values that PostgreSQL has collected on some columns of a table, you can use the pg_stats system catalog table. This table contains statistics about columns in tables, inc...
Similar Articles (10 found)
🔍 55.6% similar
What Does It Mean for a Column to Be Indexed
When optimizing queries on a database table, most developers tend to just create an index on the field to...
🔍 47.5% similar
Products & Services
Support Services
Support options for your use case, infrastructure, and budget
Workloads
Open-Source Extensions and Tools
Time Ser...
🔍 44.2% similar
6 Key Concepts, to Master Window Functions
- Introduction
- Prerequisites
- 6 Key Concepts
- Efficiency Considerations
- Conclusion
- Further reading
...
🔍 43.5% similar
25 SQL tips to level up your data engineering skills
- Introduction
- Setup
- SQL tips
- 1. Handy functions for common data processing scenarios
- 1.1...
🔍 42.1% similar
How to do Change Data Capture (CDC), using Singer
Introduction
Change data capture is a software design pattern used to track every change(update, ins...
🔍 42.0% similar
What are Common Table Expressions(CTEs) and when to use them?
- Introduction
- Setup
- Common Table Expressions (CTEs)
- Performance comparison
- Tear...
🔍 41.4% similar
How to Join a fact and a type 2 dimension (SCD2) table
- Introduction
- What is an SCD2 table and why use it?
- Setup
- Joining fact and SCD2 tables
-...
🔍 41.3% similar
PostgreSQL / Inserting and modifying data
How to use `INSERT ON CONFLICT` to upsert data in PostgreSQL
Introduction
PostgreSQL lets you either add or ...
🔍 40.2% similar
There’s a tried-and-true architecture that I’ve seen many times for supporting your web services and applications:
- PostgreSQL for data storage
- Red...
🔍 40.0% similar
What is an Open Table Format? & Why to use one?
- 1. Introduction
- 2. What is an Open Table Format (OTF)
- 3. Why use an Open Table Format (OTF)
- 4....