Inherited tables vs UNION ALL views

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Inherited tables vs UNION ALL views
Date: 2006-09-14 12:26:10
Message-ID: 82hczatz19.fsf@mid.bfk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm going to create a (manually) partioned table and wonder whether I
should use inherited tables or an explicitly created view using UNION
ALL. Constraint exclusion is not important for this application
(major updates will directly target the individual tables).

After these considerations, is there still a difference between the
two approaches?

--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Durlacher Allee 47 tel: +49-721-96201-1
D-76131 Karlsruhe fax: +49-721-96201-99

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Berend Tober 2006-09-14 12:38:17 Re: remote duplicate rows
Previous Message Andrews, Chris 2006-09-14 12:19:27 Re: remote duplicate rows