Re: Automating Partitions in PostgreSQL - Query on syntax - Mailing list pgsql-hackers

From vacuum@quantentunnel.de
Subject Re: Automating Partitions in PostgreSQL - Query on syntax
Date
Msg-id 20090421162328.311010@gmx.net
Whole thread Raw
In response to Re: Automating Partitions in PostgreSQL - Query on syntax  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Automating Partitions in PostgreSQL - Query on syntax  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
-------- Original-Nachricht --------
> Datum: Tue, 21 Apr 2009 17:50:02 +0200
> Von: Csaba Nagy <nagy@ecircle-ag.com>
> An: Robert Haas <robertmhaas@gmail.com>
> CC: Kedar Potdar <kedar.potdar@gmail.com>, Greg Stark <stark@enterprisedb.com>, pgsql-hackers@postgresql.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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: psql with "Function Type" in \df
Next
From: "Joshua D. Drake"
Date:
Subject: Re: psql with "Function Type" in \df