Greg Stark kirjutas E, 01.12.2003 kell 18:15:
> Separate OS partitions is a reasonable use of partitioned tables, but the
> biggest advantage is being able to drop and load partitions very quickly, and
> without impacting performance at all. loading or dropping millions of records
> becomes a simple DDL operation instead of a huge DML operation.
How does that mix with foreign key checks ?
------------------
Hannu
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
