Unix Technical Forum

Re: pgsql: Improve wording.

This is a discussion on Re: pgsql: Improve wording. within the pgsql Hackers forums, part of the PostgreSQL category; --> Martijn van Oosterhout wrote: > On Mon, Dec 17, 2007 at 01:48:31PM +0000, Alvaro Herrera wrote: > > Log ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-15-2008, 11:37 PM
Alvaro Herrera
 
Posts: n/a
Default Re: pgsql: Improve wording.

Martijn van Oosterhout wrote:
> On Mon, Dec 17, 2007 at 01:48:31PM +0000, Alvaro Herrera wrote:
> > Log Message:
> > -----------
> > Improve wording.


> I'd suggest removing everything between the parentheses, or perhaps
> something like: By tracking allocated memory rather than used memory
> it removes the possibilty of failing in a page fault. This option also
> require you allocate enoghh swap to cover all possible eventualities,
> though in production it will not be used.


I agree that the parenthised phrase should be removed.

http://developer.postgresql.org/cvsw...1.387&r2=1.391

I think your proposed wording is removed enough from what the
complainant was saying that it is not worth to stick it in. The point
here is, to what extent do we want to spoon-feed careless sysadmins?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-15-2008, 11:37 PM
Martijn van Oosterhout
 
Posts: n/a
Default Re: pgsql: Improve wording.

On Tue, Dec 18, 2007 at 09:32:51AM -0300, Alvaro Herrera wrote:
> Martijn van Oosterhout wrote:
> > On Mon, Dec 17, 2007 at 01:48:31PM +0000, Alvaro Herrera wrote:
> > > Log Message:
> > > -----------
> > > Improve wording.

>
> I agree that the parenthised phrase should be removed.
>
> http://developer.postgresql.org/cvsw...1.387&r2=1.391


That's fine with me. It's just that I figured that if we're going to
add something, we should at least add something factually accurate.

> I think your proposed wording is removed enough from what the
> complainant was saying that it is not worth to stick it in. The point
> here is, to what extent do we want to spoon-feed careless sysadmins?


Not sure what the complaint was. The only useful advice I can think of
is that before turning it on you need to makes sure you have lots of
swap. For the rest, I think the wording was fine as it was.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFHZ+I4IB7bNG8LQkwRAhb+AJ4oyu3biyM2EobPZYfS3Y HRzXm6AgCcDZs5
43QYww6PdqkQK6QnRXAjzmY=
=KI7O
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-15-2008, 11:38 PM
Bruce Momjian
 
Posts: n/a
Default Re: pgsql: Improve wording.

Alvaro Herrera wrote:
> Martijn van Oosterhout wrote:
> > On Mon, Dec 17, 2007 at 01:48:31PM +0000, Alvaro Herrera wrote:
> > > Log Message:
> > > -----------
> > > Improve wording.

>
> > I'd suggest removing everything between the parentheses, or perhaps
> > something like: By tracking allocated memory rather than used memory
> > it removes the possibilty of failing in a page fault. This option also
> > require you allocate enoghh swap to cover all possible eventualities,
> > though in production it will not be used.

>
> I agree that the parenthised phrase should be removed.
>
> http://developer.postgresql.org/cvsw...1.387&r2=1.391
>
> I think your proposed wording is removed enough from what the
> complainant was saying that it is not worth to stick it in. The point
> here is, to what extent do we want to spoon-feed careless sysadmins?


OK, I have removed the paratheses paragraph about fork() and added link
to an article about the OOM:

http://lwn.net/Articles/104179/

On Linux 2.6 and later, an additional measure is to modify the
kernel's behavior so that it will not <quote>overcommit</> memory.
Although this setting will not prevent the <ulink
url="http://lwn.net/Articles/104179/">OOM killer</> from being invoked
altogether, it will lower the chances significantly and will therefore
lead to more robust system behavior. This is done by selecting strict
overcommit mode via <command>sysctl</command>:

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-15-2008, 11:38 PM
Bruce Momjian
 
Posts: n/a
Default Re: pgsql: Improve wording.

Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> On Tue, Dec 18, 2007 at 09:32:51AM -0300, Alvaro Herrera wrote:
> > Martijn van Oosterhout wrote:
> > > On Mon, Dec 17, 2007 at 01:48:31PM +0000, Alvaro Herrera wrote:
> > > > Log Message:
> > > > -----------
> > > > Improve wording.

> >
> > I agree that the parenthised phrase should be removed.
> >
> > http://developer.postgresql.org/cvsw...1.387&r2=1.391

>
> That's fine with me. It's just that I figured that if we're going to
> add something, we should at least add something factually accurate.
>
> > I think your proposed wording is removed enough from what the
> > complainant was saying that it is not worth to stick it in. The point
> > here is, to what extent do we want to spoon-feed careless sysadmins?

>
> Not sure what the complaint was. The only useful advice I can think of
> is that before turning it on you need to makes sure you have lots of
> swap. For the rest, I think the wording was fine as it was.


We are back to the old wording, but a link to an OOM article was added:

http://lwn.net/Articles/104179/

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:36 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com