Re: Is there anything equivalent to Oracle9i's list

On 12 Feb 2003, Jeff Bearer wrote:

> I tried to post this a few days ago but I don't think it made it to the
> list, if It did I apologize.
>
> I've recently learned that Oracle has the ability to partition table
> data, Oracle9i's list partitioning feature.
>
> http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html
>
> I'm trying to find out if Postgres or any open source database has
> something equivalent to this.

Not yet. There's some work going on over in the hackers list with
tablespaces.

For now, you can "cheat" by creating your table, shutting down postgresql,
moving the file that represents the table to another drive, and then soft
linking it to the original location. Pain in the butt but it works.

You can use uid2name from the contrib directory if you want an easy way to
find out what the numerical name of your tables and databases are to move
them around.

You can also build database clusters wholly on other storage than primary
using environmental variables and the initlocation command. That's
somewhat easier than moving individual files and indexes around, and you
don't have to shut down postgresql to do it.