Dedicated PostgreSQL System

You can test your OS and pg configurations with pgbench:
http://www.postgresql.org/docs/9.2/static/pgbench.html

<http://www.postgresql.org/docs/9.2/static/pgbench.html&gt; Some performance
tunning tips can be found in PG wiki:
http://wiki.postgresql.org/wiki/Performance_Optimization

jov

2013/1/2 Carlos Mennens <carlos.mennens@gmail.com>

Hello All,

I'm trying to understand what exact parameters or configurations are
adjusted when a PostgreSQL database system is going to be used as a
'stand-alone' or 'dedicated' server versus a shared or embedded
database system? I have a server that's only going to be dedicated to
running Linux and PostgreSQL software. Can someone please help me
understand a few things I need to view or test with in order to get
the most utilization from PostgreSQL & the dedicated hardware it will
sit on top?

--
Carlos Mennens

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
jov
blog: http:amutu.com/blog

On 02/01/13 14:30, Carlos Mennens wrote:

Hello All,

I'm trying to understand what exact parameters or configurations are
adjusted when a PostgreSQL database system is going to be used as a
'stand-alone' or 'dedicated' server versus a shared or embedded
database system? I have a server that's only going to be dedicated to
running Linux and PostgreSQL software. Can someone please help me
understand a few things I need to view or test with in order to get
the most utilization from PostgreSQL & the dedicated hardware it will
sit on top?

--
Carlos Mennens

I've found the following publication very useful, especially information
on the various file systems you can use to support the actual database
files:-

PostgreSQL 9.0 High Performance*
Paperback:* 442 pages*
Publisher:* PACKT PUBLISHING (30 Oct 2010)*
Language:* English*
ISBN-10:* 184951030X*
ISBN-13:* 978-1849510301

You can get a copy from Amazon (other online webstores are
available...........)