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

From Scott Ribe
Subject Re: How to expand existing table-space
Date
Msg-id BEBEF3B8-2A97-4947-B6EA-304749CF6A88@elevated-dev.com
Whole thread Raw
In response to Re: How to expand existing table-space  (Ravi Krishna <sravikrishna3@gmail.com>)
Responses Re: How to expand existing table-space  (Ravi Krishna <sravikrishna3@gmail.com>)
List pgsql-admin
On May 26, 2015, at 1:54 PM, Ravi Krishna <sravikrishna3@gmail.com> wrote:
>
> I guess one easy way for large tables is to break it up to small
> tables via inheritance and each table assigned to a different
> tablespace.

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. 

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







pgsql-admin by date:

Previous
From: danny
Date:
Subject: Re: PSQL
Next
From: Ravi Krishna
Date:
Subject: Re: How to expand existing table-space