Indexes are a perfect tool to finding a certain value or some kind of range in a table. It is possible to speed up a…
View More Speeding Up “min” and “max” functions in postgresql
Category: Postgres
Postgres
How to Use Materialized Views in PostgreSQL
Introduction: About Views and Materialized Views For a complex SQL query, it is impractical to rewrite the entire query every time its results are needed. Views solve…
View More How to Use Materialized Views in PostgreSQL
Postgres — Live Table Partitioning
the partitioning of 1TB of data on a live system, with zero downtime Summary A few months ago we faced an engineering challenge of having…
View More Postgres — Live Table Partitioning
Partitioning Existing Tables in Postgres
So, your database is growing rapidly, as, ideally, is your business. The problem is, its performance is getting worse. You’re starting to wonder whether partitioning…
View More Partitioning Existing Tables in Postgres
PostgreSQL “bind variable peeking”
custom vs. generic plans With my Oracle database background, I know how important it is to balance the pros and cons of using bind variables…
View More PostgreSQL “bind variable peeking”
Postgresql PREPARE — prepare a statement for execution
Synopsis PREPARE name [ ( data_type [, …] ) ] AS statement Description PREPARE creates a prepared statement. A prepared statement is a server-side object that…
View More Postgresql PREPARE — prepare a statement for execution
Partition an existing table on PostgreSQL
Release after release PostgreSQL is better and better on table partitioning, if you do run a version12 or 13 today you must have a look…
View More Partition an existing table on PostgreSQL
Partitioning in Postgres, 2022 edition
Partitioned tables aren’t an everyday go to, but are invaluable in some cases, particularly when you have a high volume table that’s expected to keep…
View More Partitioning in Postgres, 2022 edition
Selectivity vs Cardinality
What is selectivity? Selectivity is the estimated proportion of the rows that will return from our query based on the total rows of that table.…
View More Selectivity vs Cardinality
DBA Interview Questions
1-Explain the security practices such as LDAP SSL SSO and certificate management LDAP: Lightweight Directory Access Protocol–LDAP is a tool for extracting and editing data…
View More DBA Interview Questions