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
Tag: postgresql
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
Schema vs User (Role) in Postgres
In Postgres and Oracle schemas and users (roles) are different entities. When you create a user in Oracle it is a schema at the same…
View More Schema vs User (Role) in Postgres