Re: Re: "--tuning" compile and runtime option (?)

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "John Gray" <jgray(at)beansindustry(dot)co(dot)uk>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: "--tuning" compile and runtime option (?)
Date: 2001-04-10 14:47:13
Message-ID: 006301c0c1cd$21435090$0b51000a@epox450
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Indeed, as an avid user (and tuner, I suppose) of PostgreSQL, I can't
see how any configure option would be faster or better than the existing
command line /config file parameters -- it would only serve to make things
harder to deal with IMHO. "Tuning" PostgreSQL is pretty simple, and is
explained pretty well throughout the manual (especially in the section
titled "Understanding Performance"). We have -S -B and the fsync options,
<Austin Powers Voice> That's about it.. </Austin Powers Voice> --- right?
All are explained in the manual and are as easy to use as anyone could
ask... Any OS tuning should be left up to the administrator as that's what
administrators are for :-)

Just my humble $0.02 worth..

-Mitch
Software development :
You can have it cheap, fast or working. Choose two.

----- Original Message -----
From: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "John Gray" <jgray(at)beansindustry(dot)co(dot)uk>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Tuesday, April 10, 2001 10:37 AM
Subject: Re: Re: "--tuning" compile and runtime option (?)

>
> The problem is that I can't figure out what would be tuned by these
> options. We only have 2-3 parameters that can be changed.
>
>
> > I can understand why there might be some resistance to the idea of
> > adding performance tuning flags into the server rather than documenting
> > existing settings better, but I think a compromise would be possible.
> >
> > Could we develop a helper application that takes the --tuning
> > superserver argument and translates that into a set of options to pass?
> > That way, fine-tuning by hand is still practical, but for those who just
> > want a good first set of values, a tuning helper application that looks
> > at system memory, processor speed, and a user-supplied indication of the
> > system's purpose and produces a set of postmaster options might be the
> > way to approach this. And we don't bloat the server with extra
> > algorithms. There is no dependency on this utility, either (assuming we
> > continue to use workable defaults for postmaster options!) but it may
> > benefit some people to use it.
> >
> > I really like the performance hints thing too.
> >
> > John
> >
> > --
> > John Gray
> > Tel +44-7974-100-584
> > mailto:jgray(at)beansindustry(dot)co(dot)uk
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Darren King 2001-04-10 15:13:19 RE: Re: Re: "--tuning" compile and runtime option (?)
Previous Message Bruce Momjian 2001-04-10 14:37:05 Re: Re: "--tuning" compile and runtime option (?)