| From: | Ben Chobot <bench(at)silentmedia(dot)com> |
|---|---|
| To: | Jeremy Schneider <schneider(at)ardentperf(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: typical active table count? |
| Date: | 2023-06-27 16:32:24 |
| Message-ID: | 0cc7b26e-3766-50c9-6212-4e2ed281b822@silentmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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:
> 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
>
> --
> http://about.me/jeremy_schneider
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirk Wolak | 2023-06-27 18:11:57 | Re: pb with join plan |
| Previous Message | Jeffrey Walton | 2023-06-27 16:22:23 | Re: When will trusted PL/Python be supported? |