| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | JM <jerome(at)gmanmi(dot)tv> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Spanning tables |
| Date: | 2004-12-11 03:55:39 |
| Message-ID: | 20041211035539.GB62930@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 09, 2004 at 01:07:43PM +0800, JM wrote:
> Im wondering sooner or later my disk will be filled-up by postgres's data..
>
> Can anyone give some suggestion on how to deal with this. In oracle you can
> just assign tables on a diff partition.
In PostgreSQL 8.0 you'll be able to use tablespaces. For earlier
versions, see the "Alternative Locations" section of the "Managing
Databases" chapter in the documentation, as well as the documentation
for "initlocation" under "PostgreSQL Server Applications" and CREATE
DATABASE under "SQL Commands."
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2004-12-11 04:01:39 | Re: How to get rid of notices for create table? |
| Previous Message | itamar | 2004-12-11 03:54:09 | ERROR: relation "table" does not exist - HELP |