Re: PostgreSQL vs. MySQL

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


Totally agree.

---------------------------------------------------------------------------

Josh Berkus wrote:
> 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
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Neil Conway 2003-10-08 18:28:45 Re: PostgreSQL vs. MySQL
Previous Message Josh Berkus 2003-10-08 18:05:47 Re: PostgreSQL vs. MySQL

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2003-10-08 18:28:45 Re: PostgreSQL vs. MySQL
Previous Message Peter Eisentraut 2003-10-08 18:05:51 Re: Call for Speakers / Presenters

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2003-10-08 18:28:45 Re: PostgreSQL vs. MySQL
Previous Message Jeff 2003-10-08 18:11:23 Re: Sun performance - Major discovery!

Browse pgsql-performance by date

  From Date Subject
Next Message Dror Matalon 2003-10-08 18:18:19 Re: Speeding up Aggregates
Previous Message Jeff 2003-10-08 18:11:23 Re: Sun performance - Major discovery!