Title: Re: [ADMIN] Table partitioning
I do not have remote access
right now via psql.
from pgAdmin, the table definition is as
follows:
CREATE TABLE tblksraw( devicename varchar(50) NOT
NULL, accountno int8 NOT NULL, testtime timestamp NOT
NULL, replytxt varchar(1024), replyval
Can we see the output of \d tablename as well as EXPLAIN ANALYZE of the
select?
On Wed, Apr 26, 2006 at 02:48:50PM -0600, Benjamin Krajmalnik wrote:
> Actually, right now there is no data in those partitions.
>
> All of the data is currently in the parent table (I have not yet created
> the trigg
Actually, right now there is no data in
those partitions.
All of the data is currently in the parent
table (I have not yet created the trigger which will route the data to the
correct partition).
I just found to items intriguing –
first, that the indices and other properties other than th
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
--
T
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
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
---(end of broadcast)---
TIP 6: Have you searched our list archives?
