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>
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? |
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? |