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 :-(
In response to
pgsql-admin by date
|Next:||From: Gaetano Mendola||Date: 2005-02-25 00:40:08|
|Subject: Re: Partitioning Option?|
|Previous:||From: Joel Fradkin||Date: 2005-02-24 21:57:44|
|Subject: Re: lowercase function|