[Bizgres-general] partitioned tables and indexes

[Charly CLAIRMONT]

Hi,

I have installed Bizgres on my server which has this features :
OS : Fédora Core 4
cpu : AMD 2.8 GHz
RAM : 1024 Mo.

I insert about 10 Go datas, I have partitinned my fact table following 
date. That is to say for each day , a daughter table. However I  have 
created my index on the mother table , not on the daugther (I think that 
this indexes would propage on the daugthers). In fact I think I make a 
mistake ! No ?

Also each table represents about 2 Go and I have only 1 Go of RAM. I 
have red that table size must not be to big as my RAM amount ! I want to 
knaw if this rules will be valid for my oxn context.

Tahnks a lot.


Charly CLAIRMONT
----------------
ALTIC, une ALTernative à votre système d'Information et de Communication
mail : charly.clairmont at altic.org
mob  : +33(0)661736013
tel  : +33(0)870286663
site : www.altic.org