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

From Bruce Momjian
Subject Re: PostgreSQL vs. MySQL
Date
Msg-id 200310081815.h98IFw416827@candle.pha.pa.us
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL  (Josh Berkus <josh@agliodbs.com>)
List 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Re: Sun performance - Major discovery!
Next
From: Dror Matalon
Date:
Subject: Re: Speeding up Aggregates