On Fri, Oct 08, 2004 at 10:46:56AM -0400, Doug Y wrote: > Michael Fuhr wrote: > > > >Does postgresql.conf have stats_command_string = true? > > > Thanks, setting that did the trick.... whats the performance hit for > having it enabled?
I haven't done any tests to determine the performance penalty; maybe one of the developers or somebody who's done some benchmarks can comment. The "Annotated postgresql.conf and Global User Configuration (GUC) Guide"[1] says that "Enabling statistics collection costs a small amount of time per query, but is invaluable for debugging and performance tuning." [1] http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
