SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 03:12 AM
| ||||
| ||||
 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      |
|
04-12-2008, 03:12 AM
| |||
| |||
| Re: Overhead for stats_command_string et al, take 2 Bruce Momjian <bruce@momjian.us> writes: > Oh, good point. Do we remove stats_command_string? You mean, remove the option to turn it off? I don't think so. Aside from whatever remaining overhead there is, there's a possible security argument to be made that one might not want one's commands exposed, even to other sessions with the same userid. regards, tom lane ---------------------------(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 |
|
04-12-2008, 03:13 AM
| ||||
| ||||
| Re: Overhead for stats_command_string et al, take 2 Tom Lane wrote: > Bruce Momjian <bruce@momjian.us> writes: > > Oh, good point. Do we remove stats_command_string? > > You mean, remove the option to turn it off? I don't think so. Aside > from whatever remaining overhead there is, there's a possible security > argument to be made that one might not want one's commands exposed, > even to other sessions with the same userid. OK. -- 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 2: Don't 'kill -9' the postmaster |
 |
« Re: vacuum, performance, and MVCC
|
Re: [COMMITTERS] pgsql: Change the row constructor syntax (ROW(...)) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:26 PM.
