large number of tables and postgres query performace

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

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


Updated December 18, 2017 11:06 AM

Updated September 09, 2016 09:02 AM

Updated September 09, 2016 09:02 AM

Updated December 17, 2018 11:06 AM

Updated January 21, 2018 19:06 PM