Re: Changing FS when full

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing FS when full
Date: 2010-01-22 00:28:20
Message-ID: 4B58F124.7090307@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fernando Schapachnik wrote:
> I could play soft links tricks, but I'm afraid of paying the
> FS-traversal penalty on each file access (is that right?).
>

Compared to everything else that goes into I/O, symlink traversal
overhead is pretty low.

> So, any way of instructing PG (8.1 if that matters) to place those
> files elsewhere without an initdb?
>

You can create another table just like the original on a tablespace
using the new storage, drop the original, and then rename the new one to
the original name. This is described as "another way to cluster data"
in the Notes section of
http://www.postgresql.org/docs/8.4/static/sql-cluster.html , and it has
a few warnings related to information that can be lost in this
situation. Make sure you've moved all temporary files onto the new
filesystem first, observing the warning about that there too.

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng Cheok 2010-01-22 01:57:14 void stored procedure does return something?
Previous Message Greg Smith 2010-01-22 00:22:50 Re: \dt+ sizes don't include TOAST data