Hi admins, Is there a limit to number of tables that a cluster can support?
At the moment, one of my clusters has about 250k user tables (plus 150k toast tables) across a hundred schemas within a single database. My application team wants to double the number of schemas (and with it the tables)I am looking for both pros and cons of doing this and what tuning can help this cluster perform acceptably.
My questions are 1. Is there a limit to number of tables a cluster can support effectively?2. My guess is autovacuum would have to be tuned. Current gucs for this are max_autovacuum_workers = 6maintenance_work_mem = 1GBautovacuum_vacuum_scale_factor = 0.2autovacuum_vacuum_cost_delay = 20msAre there any potential problems that I need to think about ?My machine specs are as below.RAM 256GB32-core CPU7TB SSDthankskarthik
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных