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 <amitabhk...@gmail.com> wrote: > 2010/8/9 Sim Zacks <s...@compulab.co.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 > >
