Search Postgresql Archives

index update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: index update
From: Pawel Veselov <pawel.veselov@xxxxxxxxx>
Date: Tue, 17 Jul 2012 21:02:46 -0700

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.

Follow-Ups:
- Re: index update
  - From: Craig Ringer

Prev by Date: Re: installation problem with postgres password
Next by Date: Re: index update
Previous by thread: Chicken/egg problem with range types
Next by thread: Re: index update
Index(es):
- Date
- Thread

[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]