| From: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | "Thomas Lee" <tom(at)vector-seven(dot)com> |
| Cc: | <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: A GUC variable to replace PGBE_ACTIVITY_SIZE |
| Date: | 2008-06-24 13:03:36 |
| Message-ID: | 4860F0A8.3060303@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
I'd like to see some quick testing of this thing mentioned in the comments:
> /*
> * XXX if pgstat_track_activity_query_size is really large,
> * it might be best to use strcpy not memcpy for copying the
> * activity string?
> */
If we make it a GUC, there will be people running with "really large"
pgstat_track_activity_query_size settings. In fact I wouldn't be
surprised if people routinely cranked it up to the 10-100 KB range, just
in case.
It's going to be platform-dependent, for sure, but some quick
micro-benchmarks of where the break-even point between memcpy and strcpy
lies would be nice.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lee | 2008-06-24 14:16:32 | Re: [UPDATED] A GUC variable to replace PGBE_ACTIVITY_SIZE |
| Previous Message | Bruce Momjian | 2008-06-24 12:29:44 | Re: [HACKERS] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout |