| From: | "Alex Hunsaker" <badalex(at)gmail(dot)com> |
|---|---|
| To: | "Rainer Mager" <rainer(at)vanten(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: best use of another drive |
| Date: | 2008-09-09 05:13:14 |
| Message-ID: | 34d269d40809082213q6359d873h1132ddbf6bfe1baf@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer(at)vanten(dot)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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Smiley | 2008-09-09 08:06:17 | Re: too many clog files |
| Previous Message | Rainer Mager | 2008-09-09 04:35:12 | Re: best use of another drive |