| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-performance(at)postgresql(dot)org, Carlos Benkendorf <carlosbenkendorf(at)yahoo(dot)com(dot)br> |
| Subject: | Re: How much expensive are row level statistics? |
| Date: | 2005-12-15 23:44:48 |
| Message-ID: | 20051215234448.GA47382@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
On Mon, Dec 12, 2005 at 10:20:45PM -0500, Tom Lane wrote:
> Given the rather lackadaisical way in which the stats collector makes
> the data available, it seems like the backends are being much too
> enthusiastic about posting their stats_command_string status
> immediately. Might be worth thinking about how to cut back the
> overhead by suppressing some of these messages.
Would a GUC setting akin to log_min_duration_statement be feasible?
Does the backend support, or could it be easily modified to support,
a mechanism that would post the command string after a configurable
amount of time had expired, and then continue processing the query?
That way admins could avoid the overhead of posting messages for
short-lived queries that nobody's likely to see in pg_stat_activity
anyway.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-16 00:06:39 | Re: How much expensive are row level statistics? |
| Previous Message | Qingqing Zhou | 2005-12-15 23:15:51 | Re: Which qsort is used |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-16 00:06:39 | Re: How much expensive are row level statistics? |
| Previous Message | Pierre Girard | 2005-12-15 20:56:27 | Solaris cc compiler on amd: PostgreSQL does not have native spinlock support on this platform |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-16 00:06:39 | Re: How much expensive are row level statistics? |
| Previous Message | Craig A. James | 2005-12-15 23:06:03 | Overriding the optimizer |