| From: | vacuum(at)quantentunnel(dot)de |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, robertmhaas(at)gmail(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org, stark(at)enterprisedb(dot)com, kedar(dot)potdar(at)gmail(dot)com |
| Subject: | Re: Automating Partitions in PostgreSQL - Query on syntax |
| Date: | 2009-04-21 16:23:28 |
| Message-ID: | 20090421162328.311010@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
-------- Original-Nachricht --------
> Datum: Tue, 21 Apr 2009 17:50:02 +0200
> Von: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
> An: Robert Haas <robertmhaas(at)gmail(dot)com>
> CC: Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>, Greg Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
> Betreff: Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax
> > The big win that is associated with table partitioning is using
> > constraint exclusion to avoid unnecessary partitions scans.
there is no reason for not using the 'CASE condition' for constraint exclusion.
--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!* http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2009-04-21 16:26:13 | Re: psql with "Function Type" in \df |
| Previous Message | Alvaro Herrera | 2009-04-21 16:19:57 | Re: psql with "Function Type" in \df |