Re: PostgreSQL doesn't use index-only scan if there is an expression in index

2024-02-15 Thread Laurenz Albe
On Thu, 2024-02-15 at 17:37 +0300, Pavel Kulakov wrote: > Hello, >   > PostgreSQL doesn't use 'Index Only Scan' if there is an expression in index. >   > The documentation says that PostgreSQL's planner considers a query to be > potentially > executable

PostgreSQL doesn't use index-only scan if there is an expression in index

2024-02-15 Thread Pavel Kulakov
Hello, PostgreSQL doesn't use 'Index Only Scan' if there is an expression in index. The documentation says that PostgreSQL's planner considers a query to be potentially executable by index-only scan only when all columns needed by the query are available from the