Re: [PATCHES] improve overcommit docs

2003-11-16 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes:
 At the time I wrote the original 2.6 was not out even in prerelease, 
 which is why I was deliberately somewhat vague about it. It is still in 
 prerelease, and it will in fact work slightly differently from what was 
 in some 2.4 kernels - there are 2 settings that govern this instead of 
 1.

Okay, I revised that section yet again based on this info:
http://candle.pha.pa.us/main/writings/pgsql/sgml/kernel-resources.html#AEN17043
Thanks for the update.

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [PATCHES] improve overcommit docs

2003-11-16 Thread Andrew Dunstan
That covers it extremely well.

cheers

andrew

Tom Lane wrote:

Andrew Dunstan [EMAIL PROTECTED] writes:
 

At the time I wrote the original 2.6 was not out even in prerelease, 
which is why I was deliberately somewhat vague about it. It is still in 
prerelease, and it will in fact work slightly differently from what was 
in some 2.4 kernels - there are 2 settings that govern this instead of 
1.
   

Okay, I revised that section yet again based on this info:
http://candle.pha.pa.us/main/writings/pgsql/sgml/kernel-resources.html#AEN17043
Thanks for the update.
			regards, tom lane

 



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match


Re: [PATCHES] improve overcommit docs

2003-11-15 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes:
 This patch makes some improvements to the section of the documentation
 that describes the Linux 2.4 memory overcommit behavior.

Applied.  I tweaked some of the wording a bit further.

 I removed the almost content-free assertion that You will need enough
 swap space to cover your memory needs. If this is intended to
 communicate anything meaningful, can someone rephrase it, please?

Seemed pretty content-free to me too.

regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend