Check for Table Scans

[oseibonsu]

Is it possible to have pg-mem throw an error with any query that requires a complete table scan? I have a specific use case where want to make sure that all queries are using an index. This would allow us to ensure during testing that no one has created a poorly written SQL statement.

[oseibonsu]

This question has already been answered in the docs.

[oguimbal]

yes :) but beware: pg-mem use of indices is far less advanced compared to postgres => It almost only works on simple where statements and on join conditions.

=> PG might find a way to use an index, even when pg-mem tells you that it didnt.