Re: [ADMIN] using multiple partitions for a single table

2001-09-14 Thread Corn
But can I do that? e.g. There is a customers table that keeps customers record but for two company: A & B. can I store A's customers & B's customers record into two different directory? That is the mean I know for table partitioning. Is that right? thx, Corn

Re: [ADMIN] using multiple partitions for a single table

2001-09-08 Thread Taher H. Haveliwala
Thanks all for the suggestions. I've decided to go with LVM. It would appear to be the most flexible solution. Taher --- Tom Lane <[EMAIL PROTECTED]> wrote: > "Taher H. Haveliwala" <[EMAIL PROTECTED]> writes: > > Is it possible in postgres 7.1.3 to have a single > > table span multiple partiti

Re: [ADMIN] using multiple partitions for a single table

2001-09-05 Thread Tom Lane
"Taher H. Haveliwala" <[EMAIL PROTECTED]> writes: > Is it possible in postgres 7.1.3 to have a single > table span multiple partitions? Or is using RAID the > only option? RAID or LVM are the best scenario. If you're really in a bind you could manually move table segments to different partition

Re: [ADMIN] using multiple partitions for a single table

2001-09-05 Thread Chad R. Larson
At 04:55 PM 9/4/2001 , David Stanaway wrote: >On Wednesday, September 5, 2001, at 06:58 AM, Taher H. Haveliwala wrote: > >>Is it possible in postgres 7.1.3 to have a single >>table span multiple partitions? Or is using RAID the >>only option? >> >>Thanks >>Taher Yes, you can move individual f

Re: [ADMIN] using multiple partitions for a single table

2001-09-05 Thread David Stanaway
On Wednesday, September 5, 2001, at 06:58 AM, Taher H. Haveliwala wrote: > Is it possible in postgres 7.1.3 to have a single > table span multiple partitions? Or is using RAID the > only option? > > Thanks > Taher Hi there, On Linux, you can use LVM (Logical Volume Manager) to do what you wan