Re: Vacuums on large busy databases - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Vacuums on large busy databases
Date
Msg-id cone.1158625276.426992.91426.5001@35st-server.simplicato.com
Whole thread Raw
In response to Vacuums on large busy databases  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
Jim C. Nasby writes:

> BTW, on some good raid controllers (with battery backup and
> write-caching), putting pg_xlog on a seperate partition doesn't really
> help, so you might want to try combining everything.

Planning to put a busy database on second raid or perhaps some index files.
So far the second raid is highly under utilized.

> Even if you stay with 2 partitions, I'd cut pg_xlog back to just a
> simple mirror.

I am considering to put the pg_xlog back to the main raid. Primarily because
we have two hot spares.. on top of RAID 10.. so it is safer.

pgsql-performance by date:

Previous
From: Marc McIntyre
Date:
Subject: LIKE query problem
Next
From: "Luke Lonergan"
Date:
Subject: Re: Large tables (was: RAID 0 not as fast as expected)