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

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
Subject: Re: Re: "--tuning" compile and runtime option (?)
Date: 2001-04-10 14:37:05
Message-ID: 200104101437.KAA06859@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mitch Vincent 2001-04-10 14:47:13 Re: Re: "--tuning" compile and runtime option (?)
Previous Message Thomas Lockhart 2001-04-10 13:53:34 Re: Indexes not used in 7.1RC4: Bug?