Re: Re: Re: "--tuning" compile and runtime option (?)
От | Bruce Momjian |
---|---|
Тема | Re: Re: Re: "--tuning" compile and runtime option (?) |
Дата | |
Msg-id | 200104101535.LAA12563@candle.pha.pa.us обсуждение исходный текст |
Ответ на | RE: Re: Re: "--tuning" compile and runtime option (?) ("Darren King" <darrenk@insightdist.com>) |
Список | pgsql-hackers |
We do have postgresql.conf. I am unsure how I would tune those based on a single flag. > > 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 :-) > > Someday, maybe other parameters (such as some of the optimizer's default > values) will be configurable/changable on the fly. Would seem silly to > have to stop/start the server to change those. > > Just an example, I'm sure there are other internal values that admins > would like to tweak without recompiling or restarting. Would be much > nicer to login as the superuser to do it rather than shut down my site. > > darrenk > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: