9 posts tagged with "PostgreSQL"

В этой статье описано почему реляционная схема для хранения свойств растений оказалась не такой уж и удобной и как ее можно улучшить.

Чуть больше подробностей про внутренности PostgreSQL можно найти в других статьях.

In this post I'm going to describe database schema which I will use in my pet project "Seed".

It is short note how we can use full-text search in PostgreSQL.

The goal for this post:

1. Quick overview for foreign-data wrapper in PostgreSQL
2. Example of using FDW (foreign-data wrapper) between different database inside the same PostgreSQL instance

docs

Hash​

Hash table by index key. Minimum bucket count = 2. Only hash value and version are stored in bucket, without key value.

docs

Table inheritance​

In PostgreSQL we can reduce number of code which required to describe db schema with "table inheritance".

PostgreSQL basics

Book to read: PostgreSQL 14 изнутри, Егор Рогов

A bit more details about transaction isolation in PostgreSQL database.

Here, I would like to describe basic concepts or elements that exist in PostgreSQL and are its main parts.