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