Re: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Josh Berkus
Subject Re: PostgreSQL vs. MySQL
Date
Msg-id 200310081105.47527.josh@agliodbs.com
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PostgreSQL vs. MySQL
Re: PostgreSQL vs. MySQL
List pgsql-performance
Bruce,

> Yes, I think that is a good idea --- now, does it go in the install
> docs, or in the docs next to each GUC item?

Hmmm ... both, I think.   The Install Docs should have:

"Here are the top # things you will want to adjust in your PostgreSQL.conf:
1) Shared_buffers <link>
2) Sort_mem <link>
3) effective_cache_size <link>
4) random_page_cost <link>
5) Fsync <link>
etc."

Then next to each of these items in the Docs, I add 1-2 sentences about how to
set that item.

Hmmm ... do we have similar instructions for setting connection options and
pg_hba.conf?  We should have a P telling people they need to do this.

Barring an objection, I'll get to work on this.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Greg Spiegelberg
Date:
Subject: Re: Compare rows
Next
From: Jeff
Date:
Subject: Re: Sun performance - Major discovery!