Re: when can we get better partitioning?

hubert depesz lubaczewski wrote:
> hi
> i was really more than happy when i saw table partitioning in release
> info for 8.1.
> then i tried to use it, and hit some serious problem (described on
> pgsql-general).
> basically the question is - is anybody at the moment working on
> improving partitioning capabilities? like improving queries to
> partitioned tables with "ORDER BY" and "LIMIT" statements?
> if yes, when can we start thinking about release with this functionality?
>
> i, my own, do not have enough c knowledge to do it by myself, yet i
> would *really* like to have this feature improved, as it would save me
> and my coworkers a lot of work and hassle that we face right now with
> rewriting queries to ask directly partitions instead of master table,
> that got partitioned.

You could consider sponsoring one of the developers to enhance the feature.

Joshua D. Drake

>
> best regards,
>
> depesz
>

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/