From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PostgreSQL vs. MySQL |
Date: | 2003-10-08 19:58:03 |
Message-ID: | x7ekxno62c.fsf@yertle.int.kciLink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general pgsql-hackers pgsql-performance |
>>>>> "JB" == Josh Berkus <josh(at)agliodbs(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
From | Date | Subject | |
---|---|---|---|
Next Message | Srikanth Pentakota | 2003-10-09 07:06:31 | Request for Info. |
Previous Message | Neil Conway | 2003-10-08 18:28:45 | Re: PostgreSQL vs. MySQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-10-08 20:20:24 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
Previous Message | peter pilsl | 2003-10-08 19:52:48 | reset xlog on 7.1 ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-10-08 20:30:35 | Re: confused about bit strings |
Previous Message | sailesh | 2003-10-08 19:51:22 | Re: Separate shared_buffer management process |
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2003-10-08 21:48:26 | Re: Presentation |
Previous Message | Jean-Luc Lachance | 2003-10-08 19:47:24 | Re: Compare rows |