Re: go for a script! / ex: PostgreSQL vs. MySQL

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: 2003-10-10 22:59:24
Message-ID: 20031010225924.GC8664@perrin.nxad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-10-10 23:15:37 Re: Replication Bundled with Main Source.
Previous Message Ed L. 2003-10-10 22:46:20 backend exit mystery

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-10-11 00:23:31 Re: Index/Foreign Key Question
Previous Message scott.marlowe 2003-10-10 22:52:59 Re: further testing on IDE drives