| From: | Jeremy Schneider <schneider(at)ardentperf(dot)com> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | typical active table count? |
| Date: | 2023-06-27 15:55:56 |
| Message-ID: | CA+fnDAYySsNa9Bhecu=Z5sO9Ng5U=HcdH4A6MqTtgZ+GgmiPOA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Question for other PostgreSQL users
On 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Schneider | 2023-06-27 16:01:34 | typical active table count? |
| Previous Message | Adrian Klaver | 2023-06-27 15:32:08 | Re: Large scale reliable software system |