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
Month: October 2021
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
Add Notepad++ to cmd
right click Notepad++ icon on startup -> more –> open File Location right click on notepad++ -> copy paste -> c:\windows\system32 right click -> rename…
View More Add Notepad++ to cmd
WSL (Windows Subsystem Linux)
This depends on the version of WSL that you are using: In WSL1, linux applications run alongside other windows applications, memory and CPU are only used…
View More WSL (Windows Subsystem Linux)