Joshua D. Drake wrote:
> Tomeh, Husam wrote:
>
>> Does PostgreSQL support/allow "partitioning" of objects like tables and
>> indexes, like Oracle does?
>>
> We support tablespaces but not table partitioning. You can get around
> this by using namespaces and unions however.
I demonstrate that at least with 7.4.x the horizontal partition is not
applicable, see my post on performance ( "horizontal partition" )
As soon you use the view with all UNION joined with other table you loose
the index usage on that view :-(
Regards
Gaetano Mendola