Re: limits, indexes, views and query planner

2022-08-15 Thread David Rowley
On Mon, 15 Aug 2022 at 20:30, Marc Mamin wrote: > in the example below, we can see that the view test_ab prevents the usage of > the index to retrieve the top last rows. > This is a special case, as the where clause excludes data from the second > table, and the explain output do not references

limits, indexes, views and query planner

2022-08-15 Thread Marc Mamin
hello, in the example below, we can see that the view test_ab prevents the usage of the index to retrieve the top last rows. This is a special case, as the where clause excludes data from the second table, and the explain output do not references it at all. I wonder if the planner could be able