my.cnf to postgresql.conf Conversion

From: Kevin Old <kold(at)carolina(dot)rr(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Cc: pgadmin <pgsql-admin(at)postgresql(dot)org>
Subject: my.cnf to postgresql.conf Conversion
Date: 2002-10-31 22:17:23
Message-ID: 1036102643.3122.73.camel@oc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hello everyone,

I have a question about setting the variables in the postgresql.conf
file. I have the following settings in my my.cnf file for MySQL....and
need to know which variables in the postgresql.conf file would
correspond to the ones below, so that I may tune my system correctly.

set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = thread_stack=64K
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M

Any suggestions are greatly appreciated!!!!

Kevin
--
Kevin Old <kold(at)carolina(dot)rr(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message scott.marlowe 2002-10-31 22:46:59 Re: [GENERAL] my.cnf to postgresql.conf Conversion
Previous Message Will LaShell 2002-10-31 22:12:34 Re: offsite warm backup suggestions?

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-31 22:33:53 Re: 7.2.3 / SuSe Linux / S/390
Previous Message Vincent Janelle 2002-10-31 20:22:31 Re: DAFS?