Re: best use of another drive

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема Re: best use of another drive
Дата
Msg-id 34d269d40809082213q6359d873h1132ddbf6bfe1baf@mail.gmail.com
обсуждение исходный текст
Ответ на best use of another drive  ("Rainer Mager" <rainer@vanten.com>)
Список pgsql-performance
On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer@vanten.com> 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...

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Rainer Mager"
Дата:
Сообщение: Re: best use of another drive
Следующее
От: "Matt Smiley"
Дата:
Сообщение: Re: too many clog files