[Bizgres-general] partitioned tables and indexes

[Luke Lonergan]

Charly,

On 3/16/06 3:51 PM, "Charly CLAIRMONT" <charly.clairmont at altic.org> wrote:

> 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 ?

Yes - you must create the indexes on each of the child tables.
 
> 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.

Your table size can be very much larger than your RAM amount if you like.

- Luke