> 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

-- 
Sean Chittenden

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to