Postgres Pro
Downloads
Home   >   mailing lists

typical active table count? - Mailing list pgsql-general

From Jeremy Schneider
Subject typical active table count?
Date
Msg-id CA+fnDAbDN0sMTVnCrKAMuu65dyHhqXqp+hKKoO83V6LA-Bos+A@mail.gmail.com
Whole thread Raw
Responses Re: typical active table count?  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Tree view
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: Jeremy Schneider
Date:
Subject: typical active table count?
Next
From: Tom Lane
Date:
Subject: Re: When will trusted PL/Python be supported?