Re: Configuring System for Speed

From: alvis <alvis(at)datatechlabs(dot)com>
To: Brian Wipf <brian(at)clickspace(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuring System for Speed
Date: 2006-09-08 17:46:07
Message-ID: 4501AC5F.5080103@datatechlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2006-09-09 14:48:20 Re: Configuring System for Speed
Previous Message Arjen van der Meijden 2006-09-08 16:45:48 Re: Xeon Woodcrest/Dempsey vs Opteron Socket F/940 with