PGSQL GENERAL 17 SPANNING TABLES
From: jerome@no-spam (JM)
Subject: Spanning tables
Date: Thu, 9 Dec 2004 13:07:43 +0800


Hi ALL,

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.

TIA
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@no-spam so that your message can get through to the mailing list cleanly









From: mike@no-spam (Michael Fuhr)
Subject: Re: Spanning tables
Date: Fri, 10 Dec 2004 20:55:39 -0700

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/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

From: jerome@no-spam (Jerome Macaranas)
Subject: Re: Spanning tables
Date: Tue, 14 Dec 2004 14:04:08 +0800

Im using 7.3.4 is there another way?

On Monday 13 December 2004 14:52, Shridhar Daithankar wrote:
> On Thursday 09 Dec 2004 10:37 am, JM wrote:
> > Hi ALL,
> >
> > 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.
>
> You could use tablespaces in postgresql 8.0..
>
> Check this >
> http://developer.postgresql.org/docs/postgres/sql-createtablespace.html > http://developer.postgresql.org/docs/postgres/sql-createtable.html >
> HTH >
> Shridhar
--
Jerome Macaranas Systems/Network Administrator GMA New Media, Inc.
Phone: (632) 9254627 loc 202
Fax: (632) 9284553
Mobile: (632) 918-9336819
jerome@no-spam
DISCLAIMER: This Message may contain confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you received this message in error please notify your Mail Administrator and delete this message immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of GMA New Media, Inc.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

From: mike@no-spam (Michael Fuhr)
Subject: Re: Spanning tables
Date: Mon, 13 Dec 2004 23:57:01 -0700

On Tue, Dec 14, 2004 at 02:04:08PM +0800, Jerome Macaranas wrote:
> On Monday 13 December 2004 14:52, Shridhar Daithankar wrote:
> >
> > You could use tablespaces in postgresql 8.0..
>
> Im using 7.3.4 is there another way?

See my earlier followup in this thread:

http://search.postgresql.org/pgsql-general/2004-12/msg00534.php
Here are links to the referenced documentation for 7.3:

http://www.postgresql.org/docs/7.3/static/manage-ag-alternate-locs.html http://www.postgresql.org/docs/7.3/static/app-initlocation.html http://www.postgresql.org/docs/7.3/static/sql-createdatabase.html
I'd recommend testing this before doing it on a production server.
I've never done it myself so I don't know if there are any potential problems.

-- Michael Fuhr http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

From: jerome@no-spam (JM)
Subject: Re: Spanning tables
Date: Tue, 14 Dec 2004 16:33:34 +0800

hi,

i cant afford to move the database to another location.. i will still end up on lack of disk space.. i was thinking if theres a way in version 7.3.4 to move tables on a different partition or when ever i create new tables it automatically create files on a diff partition..

tia,

On Tuesday 14 December 2004 14:57, Michael Fuhr wrote:
> On Tue, Dec 14, 2004 at 02:04:08PM +0800, Jerome Macaranas wrote:
> > On Monday 13 December 2004 14:52, Shridhar Daithankar wrote:
> > > You could use tablespaces in postgresql 8.0..
> >
> > Im using 7.3.4 is there another way?
>
> See my earlier followup in this thread:
>
> http://search.postgresql.org/pgsql-general/2004-12/msg00534.php >
> Here are links to the referenced documentation for 7.3:
>
> http://www.postgresql.org/docs/7.3/static/manage-ag-alternate-locs.html > http://www.postgresql.org/docs/7.3/static/app-initlocation.html > http://www.postgresql.org/docs/7.3/static/sql-createdatabase.html >
> I'd recommend testing this before doing it on a production server.
> I've never done it myself so I don't know if there are any potential > problems.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@no-spam so that your message can get through to the mailing list cleanly