Re: Dedicated PostgreSQL System

From: Jov <zhao6014(at)gmail(dot)com>
To: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dedicated PostgreSQL System
Date: 2013-01-02 15:44:52
Message-ID: CADyrUxNmyP4LqczsSE4NCgPqVetnRXZqoOBbegsbW2YOU9qoqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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> Some performance
tunning tips can be found in PG wiki:
http://wiki.postgresql.org/wiki/Performance_Optimization

jov

2013/1/2 Carlos Mennens <carlos(dot)mennens(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Hastie 2013-01-02 15:56:05 Re: Dedicated PostgreSQL System
Previous Message Carlos Mennens 2013-01-02 14:30:42 Dedicated PostgreSQL System