Preparing sample data First, create a new table named carsthat stores fruits: CREATE TABLE cars( id SERIAL PRIMARY KEY, make VARCHAR(50) NOT NULL, model VARCHAR(50) NOT NULL );…
View More How To Delete Duplicate Rows in PostgreSQL
Indexes in Postgresql
PostgreSQL Basic Index Terminology Before describing the types of indexes in PostgreSQL and their use, letβs take a look at some terminology that any DBA…
View More Indexes in Postgresql
Query Performance in Postgres
What is Explain? EXPLAIN is a keyword that gets prepended to a query to show a user how the query planner plans to execute the…
View More Query Performance in Postgres
Scaling in Postgresql
Horizontal Scaling vs Vertical Scaling There are two main ways to scale our database… Horizontal Scaling (scale-out): Itβs performed by adding more database nodes creating…
View More Scaling in Postgresql
Postgres EXCLUSION Constraint
Exclusion constraints ensure that if any two rows are compared on the specified columns or expressions using the specified operators, at least one of these…
View More Postgres EXCLUSION Constraint
Postgres Data Types
PostgreSQL supports the following data types: Boolean Character types such as char, varchar, and text. Numeric types such as integer and floating-point number. Temporal types such as date, time, timestamp, and interval UUID for…
View More Postgres Data Types
Docker Postgres data from windows location
We can reach out postgres docker image volumes location windows: \wsl$\docker-desktop-data\version-pack-data\community\docker\volumes\
View More Docker Postgres data from windows location
postgres random data generation
add words from linux.words.backup.fedora.standard Then, you can easily create a ton of no sense description BUT searchable using dictionary words with the following steps: 1)…
View More postgres random data generation
Docker linux add sudoers, alias commit image
at docker cli with root user: #apt-get install sudo #usermod -aG sudo postgres #su – postgres postgres # sudo whoami Permanent Alias vim ~/.bashrc or…
View More Docker linux add sudoers, alias commit image
Docker Postgres Config
https://hub.docker.com/_/postgres on visual studio code : $ docker pull postgres start a postgres instance on DockerDesktop press cli #su – postgres psql postgres=# show config_file;…
View More Docker Postgres Config