Re: typical active table count?
От
Ben Chobot
Тема
Re: typical active table count?
Дата
Msg-id
0cc7b26e-3766-50c9-6212-4e2ed281b822@silentmedia.com
Ответ на
typical active table count? (Jeremy Schneider)
Список
Дерево обсуждения
typical active table count? Jeremy Schneider <schneider@ardentperf.com>
Re: typical active table count? Ben Chobot <bench@silentmedia.com>
Re: typical active table count? Jeremy Schneider <schneider@ardentperf.com>
Re: typical active table count? Adrian Klaver <adrian.klaver@aklaver.com>
Re: typical active table count? Ben Chobot <bench@silentmedia.com>
Re: typical active table count? Ron <ronljohnsonjr@gmail.com>
Re: typical active table count? Jeremy Schneider <schneider@ardentperf.com>
We certainly have databases where far more than 100 tables are updated within a 10 second period. Is there a specific concern you have?
Jeremy Schneider wrote on 6/27/23 9:01 AM:
Jeremy Schneider wrote on 6/27/23 9:01 AM:
Question for other PostgreSQL usersOn your moderately busy DB, how many different tables might receive at least one change/DML during a 10 second window?
10? 50? 100? More? Ballpark guess off the top of your head.
I'm in a discussion & there's questions about whether it's unusual to have more than 10 or so. The answer isn't clear to me.Probably worthwhile to call out partitioning explicitly (ie. if this factors into an answer then mention that fact)-Jeremy--
В списке pgsql-general по дате отправления
