Marcos Pegoraro writes:
> customer_schema text, --here is the problem, a text column.
> Until version 11 my select was using that index correctly. Then I´ve
> upgraded to 14.1, then ...
> explain analyze select customer_schema, pk from audit where customer_schema
> = current_schema and table_nam
On a multi tenant server, with hundreds of schemas with same structure, I
have an audit table shared with all of them. When any record is deleted I
add on this table tenant, table and PK values, just that. Something like
this:
drop table if exists audit;
create table audit(id serial primary key,
c
