From: | Rod Taylor <rbt(at)rbt(dot)ca> |
---|---|
To: | Sean Chittenden <sean(at)chittenden(dot)org> |
Cc: | Vivek Khera <khera(at)kcilink(dot)com>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: go for a script! / ex: PostgreSQL vs. MySQL |
Date: | 2003-10-11 01:55:34 |
Message-ID: | 1065837333.12875.1.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
On Fri, 2003-10-10 at 18:59, 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 '%'.
Rather than showing the block size, how about we change the tunables to
be physical sizes rather than block based?
effective_cache_size = 1.5GB
shared_buffers = 25MB
Percentages would be slick as well, but doing the above should fix most
of the issue -- and be friendlier to read.
From | Date | Subject | |
---|---|---|---|
Next Message | elein | 2003-10-11 01:57:36 | Re: int1? types? |
Previous Message | Bruce Momjian | 2003-10-11 01:49:05 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-10-11 02:01:12 | Re: Index/Foreign Key Question |
Previous Message | Bruce Momjian | 2003-10-11 01:49:05 | Re: go for a script! / ex: PostgreSQL vs. MySQL |