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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
