Thread: Partitioning Postgresql

Partitioning Postgresql

From
phil campaigne
Date:
Hello All,
I know that with Oracle you can partition the tables into logical subsets and
was wondering if this was also possible in postgres.

Also is postgresql supported on linux cluusters?

Thanks in advance,
Phil




Re: Partitioning Postgresql

From
Richard Huxton
Date:
phil campaigne wrote:
> Hello All,
> I know that with Oracle you can partition the tables into logical
> subsets and
> was wondering if this was also possible in postgres.

No (except by hand, with a view layered over the top).

> Also is postgresql supported on linux cluusters?

And no (at least not without specialised hardware).

It might be that with more information, someone can give more lengthy
advice though.

--
   Richard Huxton
   Archonet Ltd