Re: pgtune

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: Amitabh Kant <amitabhkant(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pgtune
Date: 2010-08-10 20:02:18
Message-ID: AC5F9493-0C6A-4853-93EB-FB143DD6B303@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 9, 2010, at 11:40 AM, tuanhoanganh wrote:

> What is the name of DW in --type=DW
> Sorry for my English.
>

DW: Data Warehouse

> Tuan Hoang Anh
>
> On Mon, Aug 9, 2010 at 6:21 PM, Amitabh Kant <amitabhkant(at)gmail(dot)com> wrote:
> 2010/8/9 Sim Zacks <sim(at)compulab(dot)co(dot)il>
>
>
>
> I just found out about pgtune and am trying it out on my server.
>
>
> I have 2.5 questions:
>
> 1) Are these settings the maximum that the server will handle, if it is
> strictly dedicated to postgresql? Meaning if I am running other stuff on
> the server as well, this would be a bad idea.
>
>
> 1a) If I have some intense plpython stored procedures, do they run in
> the postgresql memory space (ie using the memory settings from the
> postgresql.conf, or do they run under their own memory space and then I
> would have to take that into account when allocating postgresql memory?
>
>
> 2) If it sets my max_connections to 80 and would like to set it at 300,
> what would be the appropriate setting to lower at its expense?
>
>
> Sim
>
> Look at the options available in pgtune
>
>
> -M TOTALMEMORY, --memory=TOTALMEMORY
> Total system memory, will attempt to detect if
> unspecified
> -T DBTYPE, --type=DBTYPE
> Database type, defaults to Mixed, valid options are
> DW, OLTP, Web, Mixed, Desktop
> -c CONNECTIONS, --connections=CONNECTIONS
> Maximum number of expected connections, default
> depends on database type
>
> For question 1, you can set the type of server you want. For question 2, you can pass the -c parameter and it would adjust the other parameters. Not sure of 1a though.
>
>
> Amitabh Kant
>
>

--Regards,
Vibhor

In response to

  • Re: pgtune at 2010-08-09 15:40:56 from tuanhoanganh

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-08-10 20:43:31 Re: pgtune
Previous Message Jay Flattery 2010-08-10 18:42:58 fork() and dynamically loaded c functions....