Re: How to expand existing table-space

From: Ravi Krishna <sravikrishna3(at)gmail(dot)com>
To: Igor Neyman <ineyman(at)perceptron(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 19:16:18
Message-ID: CACER=P2vhE2UBFFsz4ximRy7XkEUq3rz+Xw9OX0QiUXg98irXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 26, 2015 at 3:03 PM, Igor Neyman <ineyman(at)perceptron(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-05-26 19:19:41 Re: How to expand existing table-space
Previous Message Igor Neyman 2015-05-26 19:03:08 Re: How to expand existing table-space