Re: [PERFORM] Fwd: Table Partitioning

2007-08-18 Thread Henrik
10 aug 2007 kl. 22:58 skrev Nurlan Mukhanov: Hello All. I have a table with ca. 100.000.000 records. The main idea is make Partitioning for this table (1000 or 1 tables). Let's take for example. CREATE TABLE test ( id integer, data date not null default now() ) WITHOUT OIDS; CREATE T

[PERFORM] Fwd: Table Partitioning

2007-08-17 Thread Nurlan Mukhanov
Hello All. I have a table with ca. 100.000.000 records. The main idea is make Partitioning for this table (1000 or 1 tables). Let's take for example. CREATE TABLE test ( id integer, data date not null default now() ) WITHOUT OIDS; CREATE TABLE test00 ( CHECK ( id%100 = 0 ) ) INHERITS (te