Re: [GENERAL] Spanning tables
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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Spanning tables
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 [EMAIL PROTECTED] 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
Re: [GENERAL] Spanning tables
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
Re: [GENERAL] Spanning tables
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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Spanning tables
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