Skip site navigation (1) Skip section navigation (2)

Re: Partitioning Option?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: Partitioning Option?
Date: 2005-02-25 00:39:08
Message-ID: 421E73AC.6000708@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
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





In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2005-02-25 00:40:08
Subject: Re: Partitioning Option?
Previous:From: Joel FradkinDate: 2005-02-24 21:57:44
Subject: Re: lowercase function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group