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@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 > > --Regards, Vibhor -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
