Search Postgresql Archives

Re: pgtune

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
2010/8/9 Sim Zacks <sim@xxxxxxxxxxxxxx>



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
 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux