Craig Kerstiens • 5/29/2013

Postgres Indexes – Expression/Functional Indexing

This technical article details PostgreSQL's expression (functional) indexing feature. It demonstrates creating indexes on function results, such as date_trunc for date grouping or custom PLV8 JavaScript functions for JSON data, to improve query performance for common reporting and filtering operations.

0 comments

#indexing #postgresql #Database Optimization