Hi Álvaro, and ALL,
>I tested this with one million entries, and the query you proposed was
>more than 1,000 times faster.
Sorry, I just realized that I accidentally added an unnecessary filter
condition to one of the queries.
Specifically, the extra condition was:
AND n.nspname LIKE 'many_cns'
Because of this, I was not able to measure the two queries under identical
conditions. I will rerun the benchmarks and share the updated results tomorrow.
> # Summary
> The following changes are planned for the next patch:
>
> - Changed the query (using UNION ALL)
> - Changed the columns and their order (and the sort order accordingly):
> - Schema | Table | Type | Name | Definition
> - Toggle definition verbosity with the + option
> - Added a test case: \dCN cust*.order*
>
> The following items will not be included for now (as they are not critical):
>
> - Option to switch sort order
> (e.g., sort by constraint name vs. table name)
> - Improved command name checking logic
Yeah, that sounds good to me.
Hopefully, I will also be able to submit a new patch along with the revised
measurement results tomorrow.
Regards,
Tatsuro Yamada
