pgtune

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: pgtune
Date: 2010-08-09 10:42:46
Message-ID: 4C5FDBA6.1010309@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

  • Re: pgtune at 2010-08-09 11:21:53 from Amitabh Kant
  • Re: pgtune at 2010-08-10 20:43:31 from Greg Smith

Browse pgsql-general by date

  From Date Subject
Next Message Amitabh Kant 2010-08-09 11:21:53 Re: pgtune
Previous Message Szymon Guz 2010-08-09 09:36:28 Re: Can database run a script automatically at start up?