ensure scalability, and optimize database administration processes

you can use partitioning — splitting a large table into smaller

pieces, with each row moved to a single partition according to the

partitioning key. <productname>PostgreSQL</productname> supports partitioning via table

partitioning key. <productname>&productname;</productname> supports partitioning via table

inheritance. Each partition is created as a child table with a

CHECK constraint. For example:

</para>

attribute TEXT,

start_value ANYELEMENT,

p_interval ANYELEMENT | INTERVAL,

p_count INTEGER DEFAULT NULL

p_count INTEGER DEFAULT NULL,

partition_data BOOLEAN DEFAULT TRUE)

</programlisting>

<para>

attribute TEXT,

start_value ANYELEMENT,

p_interval ANYELEMENT,

countINTEGER DEFAULT NULL

p_count INTEGER DEFAULT NULL,

partition_data BOOLEAN DEFAULT TRUE)

create_range_partitions(relation REGCLASS,

attribute TEXT,

start_value ANYELEMENT,

p_interval INTERVAL,

count INTEGER DEFAULT NULL,

p_count INTEGER DEFAULT NULL,

partition_data BOOLEAN DEFAULT TRUE)

</programlisting>

<para>