Re: How to expand existing table-space

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Ravi Krishna <sravikrishna3(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to expand existing table-space
Date: 2015-05-26 20:53:58
Message-ID: A9C73030-99A7-43E7-ABF2-6CC6A01EB5C1@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On May 26, 2015, at 2:33 PM, Ravi Krishna <sravikrishna3(at)gmail(dot)com> wrote:
>
> 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.

Yes. There’s an externally-imposed limit, and you just have to deal with it, regardless of how idiotic it might be ;-)

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rossi, Maria 2015-05-26 21:09:57 refreshing a database with pg_dump and psql
Previous Message Ravi Krishna 2015-05-26 20:33:49 Re: How to expand existing table-space