| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Sean Chittenden <sean(at)chittenden(dot)org> |
| Cc: | Vivek Khera <khera(at)kcilink(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Date: | 2003-10-11 01:49:05 |
| Message-ID: | 200310110149.h9B1n5905115@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-10-11 01:55:34 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Manfred Koizar | 2003-10-11 01:42:57 | Re: int1? types? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-10-11 01:55:34 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Stephan Szabo | 2003-10-11 00:23:31 | Re: Index/Foreign Key Question |