Re: Re: Re: "--tuning" compile and runtime option (?) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Re: Re: "--tuning" compile and runtime option (?)
Date
Msg-id 200104101535.LAA12563@candle.pha.pa.us
Whole thread Raw
In response to RE: Re: Re: "--tuning" compile and runtime option (?)  ("Darren King" <darrenk@insightdist.com>)
List 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 by date:

Previous
From: Joel Burton
Date:
Subject: Re: problem with copy command
Next
From: Peter Eisentraut
Date:
Subject: Re: AW: Truncation of char, varchar types