Re: best use of another drive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer@xxxxxxxxxx> wrote:
> 1. Move some of the databases to the new drive. If this is a good idea, is
> there a way to do this without a dump/restore? I'd prefer to move the folder
> if possible since that would be much faster.

What like tablespaces?
http://www.postgresql.org/docs/8.3/static/manage-ag-tablespaces.html

>
> 2. Move some logs to the new drive. Again, if this is recommended I'd be
> happy to, but some directions on the right procedures would be appreciated.

By logs you mean wal logs? Depends on where your bottleneck is....
doing lots of write transactions?  Sure this might help...


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux