Intentionally splitting data in a table across files. 
Author Message
 Intentionally splitting data in a table across files.

Does PostgreSQL support (or some day will support) "partitioned tables"?
This is a feature currently available in oracle which allows you to
physically separate the data for a table based on values in a set of columns
and attach or remove the files from the table.

While searching for the answer in the existing Docs & Archives, I noted that
a table will be split across files automatically to deal with situations
where the required space exceeds operating system limits, so it appears that
at least part of the concept already exists, but I found nothing about a way
to organize the data into a particular file or take a file that hold part of
a table off-line without making a mess. This would be a great enhancement
for warehousing applications such as ours, where the ability take a
particular large chunk of data on & off line quickly is important.

Alternately, does anyone have an idea about how to address this need in a
different way using existing tools?

-Nick

---------------------------------------------------------------------
Nick Fankhauser


doxpop - Court records at your fingertips - http://www.***.com/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 23 Nov 2003 23:57:13 GMT
 Intentionally splitting data in a table across files.

Quote:

> Does PostgreSQL support (or some day will support) "partitioned tables"?

It's not on anyone's radar screen AFAIK.

Quote:
> Alternately, does anyone have an idea about how to address this need in a
> different way using existing tools?

Make a view that's a UNION of the component tables, plus rules that
cause inserts to go into the appropriate components.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Mon, 24 Nov 2003 01:04:41 GMT
 Intentionally splitting data in a table across files.


Quote:

> > Does PostgreSQL support (or some day will support) "partitioned tables"?

> It's not on anyone's radar screen AFAIK.

> > Alternately, does anyone have an idea about how to address this need in
a
> > different way using existing tools?

> Make a view that's a UNION of the component tables, plus rules that
> cause inserts to go into the appropriate components.

Tried this in 7.1.2, but it returns ERROR:  "Views on unions not
implemented."
Quote:
> regards, tom lane



Mon, 24 Nov 2003 12:00:17 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Intentionally splitting data in a table across files.

2. Intentionally splitting data in a table across files.

3. Intentionally splitting data in a table across files. (fwd)

4. Informix 2.10 Splitting Data Across File Systems?

5. Splitting tables across file systems

6. Splitting Tables Across Areas

7. Foreign key split across two tables

8. Distribute data across multiple data files

9. seeking advise on DB tables, split or not split

10. seeking advise on DB tables, split or not split

11. Scanning tables and moving data across tables

12. Split of data file


 
Powered by phpBB® Forum Software