From: Thomas F.O'Connell <tfo@sitening.com>
To: Ken Reid <Ken@homegain.com>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Table Partitioning
Date: Wed, 9 Mar 2005 09:02:39 -0600
Message-ID: <cb101ff5de3bebc918e791aad2f3aa32@sitening.com> (raw)
In-Reply-To: <C0F6DD0E8F3B9040A77F857FCFAC452A01A3DFC8@hqsxch01.homegain.com>
References: <C0F6DD0E8F3B9040A77F857FCFAC452A01A3DFC8@hqsxch01.homegain.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tfo@sitening.com, Ken@homegain.com
Subject: Re: Table Partitioning
In-Reply-To: <cb101ff5de3bebc918e791aad2f3aa32@sitening.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox