large number of tables and postgres query performace

by Manu Singhal   Last Updated June 12, 2019 06:06 AM - source

I have a scenario where there are 40000 tables in the database. but there are no huge unions. Very simple single table select queries are performing much slower than usual (table with just 600,000 rows and 10-15 columns).

Does the (large) number of tables in a database can affect query performance? If Yes, How?

Related Questions

mysql: how to improve query execution time

Updated December 18, 2017 11:06 AM

Postgres heap table performance on SSD

Updated September 09, 2016 09:02 AM

Difference between Materialization and Pipelining

Updated December 17, 2018 11:06 AM