Skip to main content

7 docs tagged with "postgres"

View all tags

B & B+ Tree

B-Trees and B+ Trees are self-balancing tree data structures that form the foundation of PostgreSQL's default index type.

Indexing

Indexes in PostgreSQL are database objects that improve the speed of data retrieval operations on tables.

Must Do

Essential advanced-level PostgreSQL questions.

Must Do

Essential beginner-level PostgreSQL questions.

Must Do

Essential intermediate-level PostgreSQL questions.

Partitioning

Table partitioning in PostgreSQL allows you to split a large table into smaller, more manageable pieces called partitions.

Sharding

Sharding is a horizontal scaling technique that distributes data across multiple database instances or servers.