Обсуждение: when can we get better partitioning?

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

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/