Re: PostgreSQL vs. MySQL

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL vs. MySQL
Date: 2003-10-08 18:05:47
Message-ID: 200310081105.47527.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general pgsql-hackers 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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2003-10-08 18:15:58 Re: PostgreSQL vs. MySQL
Previous Message Bruce Momjian 2003-10-08 17:58:57 Re: PostgreSQL vs. MySQL

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-10-08 18:05:51 Re: Call for Speakers / Presenters
Previous Message Julie May 2003-10-08 18:04:30 Re: Displaying a float8 as a full-length number

Browse pgsql-hackers by date

  From Date Subject
Next Message Manfred Koizar 2003-10-08 18:11:08 Re: [HACKERS] Cannot dump/restore text value \N
Previous Message Bruce Momjian 2003-10-08 17:58:57 Re: PostgreSQL vs. MySQL

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2003-10-08 18:11:23 Re: Sun performance - Major discovery!
Previous Message Greg Spiegelberg 2003-10-08 18:05:34 Re: Compare rows