diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2008-06-30 10:58:47 +0000 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2008-06-30 10:58:47 +0000 |
| commit | 995fb7420268c2457c9a64f41394cea54316365f (patch) | |
| tree | d8de58e9497f15da810d19c71a18f8fe6692b060 /src/backend/utils/misc | |
| parent | 7ea9b997ef07672d45278ab1c5b0634eaa090966 (diff) | |
| download | postgresql-995fb7420268c2457c9a64f41394cea54316365f.tar.gz | |
Turn PGBE_ACTIVITY_SIZE into a GUC variable, track_activity_query_size.
As the buffer could now be a lot larger than before, and copying it could
thus be a lot more expensive than before, use strcpy instead of memcpy to
copy the query string, as was already suggested in comments. Also, only copy
the PgBackendStatus struct and string if the slot is in use.
Patch by Thomas Lee, with some changes by me.
Diffstat (limited to 'src/backend/utils/misc')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 11 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 1 |
2 files changed, 11 insertions, 1 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index b3409111b1..76c6843fd6 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.456 2008/05/28 09:04:06 mha Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.457 2008/06/30 10:58:47 heikki Exp $ * *-------------------------------------------------------------------- */ @@ -1848,6 +1848,15 @@ static struct config_int ConfigureNamesInt[] = -1, -1, INT_MAX, NULL, NULL }, + { + {"track_activity_query_size", PGC_POSTMASTER, RESOURCES_MEM, + gettext_noop("Sets the size reserved for pg_stat_activity.current_query, in bytes."), + NULL, + }, + &pgstat_track_activity_query_size, + 1024, 100, 102400, NULL, NULL + }, + /* End-of-list marker */ { {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 033a74b2d4..552d856ae2 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -364,6 +364,7 @@ #track_activities = on #track_counts = on #track_functions = none # none, pl, all +#track_activity_query_size = 1024 #update_process_title = on |