"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> The next way is to individually link thinks like indexes onto other
> volumes. The procedure is basically, create the index, figure out which
> file in $PGDATA/base/oidofyourdbhere is the index, shut down postgresql,
> copy to file elsewhere, softlink it, restart apache. This setup will not
> survive reindexing or dropping / recreating the index.
It should also be noted that this hack doesn't cope well with tables or
indexes exceeding 1Gb. You'd have to separately symlink each segment,
and deal with creating new links every time the table/index grows past
another 1Gb boundary.
Tablespaces will be a lot nicer when we have them. For now, a RAID
array is definitely the best bet.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: scott.marlowe||Date: 2004-04-09 17:20:43|
|Subject: Re: sequence value of the record just inserted.|
|Previous:||From: Josh Berkus||Date: 2004-04-09 16:02:00|
|Subject: Re: [PERFORM] Raw devices vs. Filesystems|