Re: pgtune

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

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
>
>