From: | Hannu Krosing <hannu(at)skype(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Michael Glaesemann <grzm(at)seespotcode(dot)net>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, "Bort, Paul" <pbort(at)tmwsystems(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Neil Conway <neilc(at)samurai(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: GUC with units, details |
Date: | 2006-07-28 10:41:53 |
Message-ID: | 1154083313.2901.2.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Ühel kenal päeval, N, 2006-07-27 kell 01:03, kirjutas Tom Lane:
> Michael Glaesemann <grzm(at)seespotcode(dot)net> writes:
> > I've seen this mentioned a couple of times. I'm not nearly as
> > familiar with these settings as I should be, but it seems to me that
> > if the memory size *does* need to be a integral multiple of page
> > size, e.g., n * page_size = memory_size, why isn't that memory
> > configured as the integer n rather than memory_size?
>
> It is. For instance shared_buffers is configured as the number of
> buffers. What we're talking about here is ways to specify the intended
> usage with other units (eg "I want N megabytes of shared buffers") but
> that's not going to magically let you allocate half a shared buffer.
What are the plans for SHOW command ?
Will it show actual number of buffers allocated, original number
requested or actual amount allocated in units requested ?
Or some combination of above ?
> Peter's not said exactly how he plans to deal with this, but I suppose
> it'll round off one way or the other ...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia
Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2006-07-28 11:07:40 | Re: [Pgbuildfarm-members] [Fwd: RE: Build farm on Windows] |
Previous Message | Andrew Dunstan | 2006-07-28 10:41:48 | [Fwd: RE: Build farm on Windows] |