Postgres Pro
Downloads
Home   >   mailing lists

Re: typical active table count? - Mailing list pgsql-general

From Ben Chobot
Subject Re: typical active table count?
Date
Msg-id 0cc7b26e-3766-50c9-6212-4e2ed281b822@silentmedia.com
Whole thread Raw
In response to typical active table count?  (Jeremy Schneider <schneider@ardentperf.com>)
Responses Re: typical active table count?  (Jeremy Schneider <schneider@ardentperf.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Jeffrey Walton
Date:
Subject: Re: When will trusted PL/Python be supported?
Next
From: Kirk Wolak
Date:
Subject: Re: pb with join plan