Re: [GENERAL] index update

2012-07-18 Thread Thomas Munro
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? > >Thank you, > Pawel. -- Sent via pgsql-general m

Re: [GENERAL] index update

2012-07-17 Thread Pawel Veselov
On Tue, Jul 17, 2012 at 9:18 PM, Craig Ringer wrote: > 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 effect

Re: [GENERAL] index update

2012-07-17 Thread Craig Ringer
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 m

[GENERAL] index update

2012-07-17 Thread Pawel Veselov
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.