| 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: | Whole Thread | Raw Message | 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? |