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=P2vhE2UBFFsz4ximRy7XkEUq3rz+Xw9OX0QiUXg98irXA@mail.gmail.com
Whole thread Raw
In response to Re: How to expand existing table-space  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: How to expand existing table-space  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Tue, May 26, 2015 at 3:03 PM, Igor Neyman <ineyman@perceptron.com> wrote:

> I see no other way, but create new TS on the new FS and move objects (all or some of them)
> from old into new TS.

But isn't moving objects from old to new TS an offline job (the table
is locked).

This leads to obvious conclusion that in PG, no single table should be
allowed to grow beyond a reasonable limit.

Is this being addressed in future versions, like allowing a new
storage path to existing tablespace.


pgsql-admin by date:

Previous
From: Igor Neyman
Date:
Subject: Re: How to expand existing table-space
Next
From: Tom Lane
Date:
Subject: Re: How to expand existing table-space