Re: Stats for indexes on expressions

2020-12-24 Thread Tom Lane
Shantanu Shekhar writes: > I am trying to understand how the cost for a query involving indexes on > expressions is calculated. How is the statistics on the expression > maintained? For example Postgres documentation on 'Indexes on Expressions' > mentions the following example: > CREATE INDEX p

Stats for indexes on expressions

2020-12-24 Thread Shantanu Shekhar
Hello, I am trying to understand how the cost for a query involving indexes on expressions is calculated. How is the statistics on the expression maintained? For example Postgres documentation on 'Indexes on Expressions' mentions the following example: CREATE INDEX people_names ON people ((first