Inspecting GIST Index Internal Structure with PostgreSQL pageinspect Plugin (PG14)

This article demonstrates how PostgreSQL 14's pageinspect extension adds functions to examine GIST index internal pages, provides step‑by‑step SQL examples for creating a test table and index, and shows how to query opaque page info and item data using the new functions.

Database InternalsGiST indexPostgreSQL

0 likes · 4 min read

Inspecting GIST Index Internal Structure with PostgreSQL pageinspect Plugin (PG14)

Qunar Tech Salon

Dec 12, 2018 · Databases

Installing and Using the IP4R Extension for IP Address Range Queries in PostgreSQL

This article explains how to install the IP4R PostgreSQL extension via PGXS, describes its custom IP address and range data types, demonstrates common queries, functions, operators, and GiST indexing techniques, and compares its performance against bigint‑based lookups for efficient IP range handling.

ExtensionGiST indexIP address

0 likes · 17 min read

Installing and Using the IP4R Extension for IP Address Range Queries in PostgreSQL

ITPUB

Jul 12, 2016 · Databases

Practical Guide to PostgreSQL Index Optimization and Cost Analysis

This article walks through practical steps for identifying performance bottlenecks in PostgreSQL, selecting appropriate columns and index types, interpreting system statistics, and evaluating cost estimates with real‑world examples to dramatically reduce query latency.

GiST indexPostgreSQLcost estimation

0 likes · 13 min read

Practical Guide to PostgreSQL Index Optimization and Cost Analysis