| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Florian Weimer <fweimer(at)bfk(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inherited tables vs UNION ALL views |
| Date: | 2006-09-14 13:24:12 |
| Message-ID: | 27882.1158240252@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Florian Weimer <fweimer(at)bfk(dot)de> writes:
> 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).
IIRC, these should be planned equivalently in 8.2, but they go through
different planner paths in 8.1 and before --- you'll want to check the
specific queries you have in mind and see whether they get planned as
you want. C-E definitely only works on the inheritance case in 8.1.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-14 14:22:22 | Re: Question about timestamp with time zone |
| Previous Message | Jan van der Weijde | 2006-09-14 13:18:37 | Question about timestamp with time zone |