View Single Post

   
  #1 (permalink)  
Old 04-12-2008, 04:12 AM
Bruce Momjian
 
Posts: n/a
Default Re: Overhead for stats_command_string et al, take 2

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Yep, I see 8% here. I will add a patch to allow the ps display to be
> > turned off.

>
> I think we'd still want a backend to set the PS display once with its
> identification data (user/DB name and client address). It's just the
> transient activity updates that should stop.


Oh, good point. Do we remove stats_command_string? Does it have any
measurable overhead? I see a little here, like 1%.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote