postgres – Page 5

Postgres

Recursive Queries, CTE (Common Table Expression) or Self Join, Recursive Views

The CTEs are like temporary tables that exist only during the execution of the query. a simple example: Another example using a function Getting “manager tree” for…

Postgres

How To Delete Duplicate Rows in PostgreSQL

Bulent Soylu October 11, 2021 No Comments duplicate postgres

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 );…

Postgres

Indexes in Postgresql

Bulent Soylu October 11, 2021 No Comments index postgres

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…

Postgres

Query Performance in Postgres

Bulent Soylu October 11, 2021 No Comments analyze execution plan explain performance pgbench postgres query

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…

Postgres

Scaling in Postgresql

Bulent Soylu October 11, 2021 No Comments postgres scaling

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…

Postgres

Postgres EXCLUSION Constraint

Bulent Soylu October 11, 2021 No Comments constraints postgres

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…

Postgres

Postgres Data Types

Bulent Soylu October 10, 2021 No Comments data types postgres

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…

Docker Postgres

Docker Postgres data from windows location

Bulent Soylu October 9, 2021 No Comments docker postgres wsl

We can reach out postgres docker image volumes location windows: \wsl$\docker-desktop-data\version-pack-data\community\docker\volumes\

Postgres

postgres random data generation

Bulent Soylu October 9, 2021 No Comments postgres random words.list

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)…

Docker Postgres

Docker Postgres Config

Bulent Soylu October 9, 2021 No Comments docker postgres vim

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;…

DBA Notes

Tag: postgres

Recursive Queries, CTE (Common Table Expression) or Self Join, Recursive Views

How To Delete Duplicate Rows in PostgreSQL

Indexes in Postgresql

Query Performance in Postgres

Scaling in Postgresql

Postgres EXCLUSION Constraint

Postgres Data Types

Docker Postgres data from windows location

postgres random data generation

Docker Postgres Config