Re: index update

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