Sean Chittenden wrote:
> > NB> So far:
> > 
> > NB> shared_buffers = 1/16th of total memory
> > NB> effective_cache_size = 80% of the supposed kernel cache.
> > 
> > Please take into account the blocksize compiled into PG, too...
> 
> Would anyone object to a patch that exports the blocksize via a
> readonly GUC?  Too many tunables are page dependant, which is
> infuriating when copying configs from DB to DB.  I wish pgsql had some
> notion of percentages for values that end with a '%'.  -sc

Makes sense to me --- we already have some read-only GUC variables.

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to