At Amplitude, our goal is to provide easy-to-use interactive product analytics, so everyone can find answers to their product questions. In order to provide a…
View More How a single PostgreSQL config change improved slow query performance by 50x
Tag: 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…
View More Recursive Queries, CTE (Common Table Expression) or Self Join, Recursive Views
How To Delete Duplicate Rows in PostgreSQL
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