Postgresql

What is PostgreSQL # PostgreSQL is a powerful open-source relational database known for its reliability and extensibility, supporting rich data types, full-text search, JSON, and geospatial processing.

Why indexes matter # Without an index, table scans are O(n) — queries degrade quickly as data grows. A good index brings lookups down to O(log n).