Re: Table Partitioning

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Ken Reid <Ken(at)homegain(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Table Partitioning
Date: 2005-03-09 15:02:39
Message-ID: cb101ff5de3bebc918e791aad2f3aa32@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ken,

Table partitioning doesn't really exist, to the best of my knowledge,
but tablespaces, which are new to 8.0, allow for partitioning of data
(individual tables, indexes) across multiple locations on disk.

See

http://www.postgresql.org/docs/8.0/static/sql-createtablespace.html

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Mar 3, 2005, at 3:56 PM, Ken Reid wrote:

> I am new to postgres and was wondering if table partitioning
> is supported in Postgres. And if so what version and where can
> I find documentation on it.
>
> - Thank You
>
> - Ken Reid

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-09 15:19:18 Re: Slow Update
Previous Message Ricardo Valença de Assis 2005-03-09 14:44:33 Slow Update