Re: Partitions implementation with views

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Partitions implementation with views
Date: 2003-12-01 22:09:47
Message-ID: 1070316587.2388.9.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-12-01 23:04:47 Re: [CORE] Commit privs
Previous Message Bruce Momjian 2003-12-01 21:49:09 Re: remaining patches?