Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Tom Lane wrote: > >> I don't have a problem with removing it as a writable option ... but > >> I'm thinking we should leave it as a read-only GUC parameter (like > >> the several others we have already). Otherwise we'll need to add some > >> other method of finding out whether the collector is running. > > > Why would a user care? > > luser> It's not collecting statistics! > > us> Is the collector running? > > luser> How should I know? > > us> er ... > > If we don't have a way to check this, we'll regret it soon enough... > now maybe a GUC setting isn't the optimal way, but I think we need > *some* way besides ps. ps doesn't work remotely and I think there's > no simple equivalent under Windows either.
Sure, but the GUC only reports that it thinks the stats collector started, not whether it is running or not. I think 'ps' is a fine way to tell. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
