AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Evolution of Index Types in Postgres over the Last 10 Years
JSON support was introduced in Postgres around version 9/nPostgres has been adding new index types every year for the past 10 years/nB-Tree index is the foundational index type in Postgres/nGen Index is useful for columns with multiple values like arrays or JSON/nJust indexes are suitable for shapes and full-text search/nPostgres has become rich in terms of feature sets/nThe database has gained popularity and is considered cool and sexy in the last 10 years