Re: How to expand existing table-space - Mailing list pgsql-admin

From Ravi Krishna
Subject Re: How to expand existing table-space
Date
Msg-id CACER=P32F8Xp4DMdrhQcS4+6a3Pq4dwSKjS7P9MnOeVLhkmW3g@mail.gmail.com
Whole thread Raw
In response to Re: How to expand existing table-space  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: How to expand existing table-space
List pgsql-admin
> That's also a way you could migrate your current table without disrupting production.
>
> Partitioning like that is often done as a performance optimization; but it sounds like you're proposing that a file
systemcannot be expected to handle a large table in piece??? I don't understand that. 

Let us say that that the sys admins have set a limit of 1TB per FS.
This automatically implies that a single table can not grow more than
1TB, unless it is broken into smaller tables via inheritance and each
child table goes to a separate table-space. I hope I am clearer now.


pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: How to expand existing table-space
Next
From: Scott Ribe
Date:
Subject: Re: How to expand existing table-space