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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
