Re: Partitions implementation with views - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Partitions implementation with views
Date
Msg-id 1070316587.2388.9.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Partitions implementation with views  (Greg Stark <gsstark@mit.edu>)
Responses Re: Partitions implementation with views
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: remaining patches?
Next
From: Bruce Momjian
Date:
Subject: Re: [CORE] Commit privs