On Nov 26, 2007 3:05 PM, David Young <randomfire(at)gmail(dot)com> wrote:
> I recently converted to using a postgresql engine that support tablespaces.
> There's a database that I would like to move to a new tablespace for
> performance reasons. What is the safe and correct way of doing this? The
> documentation is a bit sketchy on this.
I think you'd have to first set a new default_tablespace for the db,
then you'd have to write a script to go through each object and move
it with an alter (table|index) to the new tablespace.
In response to
pgsql-admin by date
|Next:||From: Aldor||Date: 2007-12-04 11:01:12|
|Subject: Cannot kill autovacuum|
|Previous:||From: Tommy Cheng||Date: 2007-12-03 10:21:09|
|Subject: How to identify the current WAL segment file|