From: alvis <alvis@datatechlabs.com>
To: Brian Wipf <brian@clickspace.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuring System for Speed
Date: Fri, 08 Sep 2006 17:46:07 +0000
Message-ID: <4501AC5F.5080103@datatechlabs.com> (raw)
In-Reply-To: <8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com>
References: <8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com>
Brian Wipf wrote:
> I am in the process of speccing out a new box for a highly utilized
> (updates, inserts, selects) 40GB+ database. I'm trying to maximize
> performance on a budget, and I would appreciate any feedback on any of
> the following.
>
Perhaps this is off topic, but here is bit from my experience. Using
single server for both read (select) and write (insert, update, delete)
operations is the way to slow things down. Consider to split query
workload into OLTP and OLAP queries . Set up Slony replication and use
slave server for read operations only . Buy 1 cheap box (slave) and
another more expensive one for master. Keep in mind that DB schema
optimization for particular query workload is essential . You just can
not get good performance for selects if schema is optimized for inserts
and vice versa.
>
> OS:
> The consensus in the list seems to be as long as you have the 2.6
> Linux Kernel, it's really a matter of personal preference. However,
> it's hard to have a preference when you're new to the Linux world,
> like I am. Red Hat, Fedora Core, Slackware, Suse, Gentoo? I guess my
> primary goal is speed, stability, and ease of use. Any advice here, no
> matter how minimal, would be appreciated.
My answer is FreeBSD6.1.
>
> Thanks,
>
> Brian Wipf
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Best Regards,
Alvis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvis@datatechlabs.com, brian@clickspace.com
Subject: Re: Configuring System for Speed
In-Reply-To: <4501AC5F.5080103@datatechlabs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox