From: Vivek Khera <khera@kcilink.com>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL vs. MySQL
Date: Wed, 08 Oct 2003 15:58:03 -0400
Message-ID: <x7ekxno62c.fsf@yertle.int.kciLink.com> (raw)
References: <200310081758.h98Hwvr15088@candle.pha.pa.us>
<200310081105.47527.josh@agliodbs.com>
>>>>> "JB" == Josh Berkus <josh@agliodbs.com> writes:
JB> Hmmm ... both, I think. The Install Docs should have:
JB> "Here are the top # things you will want to adjust in your PostgreSQL.conf:
JB> 1) Shared_buffers <link>
JB> 2) Sort_mem <link>
JB> 3) effective_cache_size <link>
JB> 4) random_page_cost <link>
JB> 5) Fsync <link>
JB> etc."
Add:
max_fsm_relations (perhaps it is ok with current default)
max_fsm_pages
I don't think you really want to diddle with fsync in the name of
speed at the cost of safety.
and possibly:
checkpoint_segments (if you do a lot of writes to the DB for extended
durations of time) With 7.4 it warns you in the
logs if you should increase this.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: khera@kcilink.com
Subject: Re: PostgreSQL vs. MySQL
In-Reply-To: <x7ekxno62c.fsf@yertle.int.kciLink.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox