Re: [GENERAL] Optimizations for busy DB??

On Thu, 13 May 1999, Brett W. McCoy wrote:

> On Thu, 13 May 1999, Brian wrote:
> 
> > ok, so specifying -B etc to the postmaster itself has no advantages?  I
> > mean I guess you wouldn't want/need to specify those optimizations to both
> > postgres backend AND the postmaster?
> 
> Actually, you're right -- you only want to pass -B to the backend if you 
> are running it standalone, otherwise use the postmaster option.  Note, 

standalone as opposed to what?  I run it with -i and have clients all over
connecting to it? 

> though that passing -S to the postmaster is a different option than 
> passing -S to the backend (postmaster recognizes -S as 'silent mode' 
> whereas the backend recognizes -S as the sort allocation).  Check the man 
> pages for the specifics.  Just remember that the postmaster has its own 
> options while postgres (the actual backend) has its own options distinct 
> from the postmaster.
> 
> > I am assuming I will have to export all my data and reimport into 6.4.2,
> > which is a task for sure............I will make this jump soon when I have
> > some downtime.
> 
> Good project for a long weekend!
> 
> Brett W. McCoy           
>                                          http://www.lan2wan.com/~bmccoy
> -----------------------------------------------------------------------
> "If the King's English was good enough for Jesus, it's good enough for
> me!"
> 		-- "Ma" Ferguson, Governor of Texas (circa 1920)
> 

-----------------------------------------------------
Brian Feeny (BF304)     signal@shreve.net   
318-222-2638 x 109	http://www.shreve.net/~signal      
Network Administrator   ShreveNet Inc. (ASN 11881)