On 07/18/2012 12:02 PM, Pawel Veselov wrote:
Hi.
If I have a lot (10k) tables, and each table has a btree index, and
all the tables are being constantly inserted into, would all the
indexes have to be in memory, and would effectively start fighting for
space?
Quite likely, yes.
You could make it a bit more efficient by grouping inserts up and doing
batches for each table - if that's possible in your application.
10k tables is a heck of a lot. That sort of thing often implies app
design issues. Why 10k tables? What do they do?
--
Craig Ringer
