On Thu, Jan 6, 2011 at 6:20 AM, Sim Zacks wrote:
> We are about to build a new database server, our plan is to use Debian.
>
> Is there documentation of recommended server configurations for Linux, such
> as kernel parameters, preferred file system, etc that work best with
> postgresql?
>
> I'm no
On Thu, Jan 6, 2011 at 9:38 AM, Scott Marlowe wrote:
> As a followup, I'd like to point out that you can probably get more
> performance wise from hardware upgrades than from tuning your OS.
> Something as simple as an $800 caching RAID controller can make a
>
Totally agree here. Throwing hardwa
As a followup, I'd like to point out that you can probably get more
performance wise from hardware upgrades than from tuning your OS.
Something as simple as an $800 caching RAID controller can make a
workstation class machine into a monster performer, going from 250 tps
to 3000 tps with one simple
On Thu, Jan 6, 2011 at 4:20 AM, Sim Zacks wrote:
> We are about to build a new database server, our plan is to use Debian.
>
> Is there documentation of recommended server configurations for Linux, such
> as kernel parameters, preferred file system, etc that work best with
> postgresql?
This real
I don't think that it makes sense to look at PG tuning and server
tuning as two separate tasks. XFS was recently benchmarked using
bonnie++ by Greg Smith, with interesting results:
http://blog.2ndquadrant.com/en/2010/04/the-return-of-xfs-on-linux.html
That said, my guess is that the majority of l
We are about to build a new database server, our plan is to use Debian.
Is there documentation of recommended server configurations for Linux,
such as kernel parameters, preferred file system, etc that work best
with postgresql?
I'm not talking about the pg configuration, which I have seen a
