Ühel kenal päeval, N, 2006-07-27 kell 01:03, kirjutas Tom Lane: > Michael Glaesemann <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
