I'd use two of your drives to create a mirrored partition where pg_xlog
resides separate from the actual data.
RAID 10 is probably appropriate for the remaining drives.
Fortunately, you're not using Dell, so you don't have to worry about
the Perc3/Di RAID controller, which is not so compatible
If by not practical you mean, no one has implemented a multivariable
testing approach, I'll agree with you. But multivariable testing is
definitely a valid statistical approach to solving just such problems.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
It should be noted that users who use Slony can create a subscriber
node running 8.0 that subscribes to a node running 7.4.x and can
transition with only the downtime required for failover.
This obviates the need for a dump/restore.
See http://slony.info/.
-tfo
--
Thomas F. O'Connell
I've been at companies where we've had good experiences with Penguin
Computing servers.
http://www.penguincomputing.com/
I always evaluate their offerings when considering server purchases or
recommendations.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
I'm seeing some weird behavior on a repurposed server that was wiped
clean and set up to run as a database and application server with
postgres and Apache, as well as some command-line PHP scripts.
The box itself is a quad processor (2.4 GHz Intel Xeons) Debian woody
GNU/Linux (2.6.2)
37203-6320
615-260-0005
On Oct 21, 2004, at 4:05 PM, Dennis Bjorklund wrote:
On Thu, 21 Oct 2004, Thomas F.O'Connell wrote:
Aggregate (cost=0.02..0.02 rows=1 width=8) (actual
time=298321.421..298321.422 rows=1 loops=1)
- Nested Loop (cost=0.00..0.01 rows=1 width=8) (actual
time=1.771