index update

From: Pawel Veselov <pawel(dot)veselov(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: index update
Date: 2012-07-18 04:02:46
Message-ID: CAMnJ+BdwB25tu7sObPxoQFbPPAHdfSTXGUJDq-6UuENDW9QUZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thank you,
Pawel.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-07-18 04:18:25 Re: index update
Previous Message Adrian Klaver 2012-07-18 03:19:45 Re: installation problem with postgres password