On Wed, Mar 23, 2022 at 09:44:09AM +0000, Lars Aksel Opsahl wrote: > Why is temp tables with no indexes much faster system tables with indexes ? I think the "temp table" way is accidentally faster due to having no statistics, not because it has no indexes. If you run ANALYZE, you may hit the same issue (or, maybe you just need to VACUUM ANALYZE your system catalogs). -- Justin
