| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Hannu Krosing <hannu(at)skype(dot)net> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Stats collector performance improvement |
| Date: | 2006-01-08 16:49:12 |
| Message-ID: | 87wtha1x87.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Hannu Krosing <hannu(at)skype(dot)net> writes:
> Interestingly I use pg_stat_activity view to watch for stuck backends,
> "stuck" in the sense that they have not noticed when client want away
> and are now waitin the TCP timeout to happen. I query for backends which
> have been in "<IDLE>" state for longer than XX seconds. I guess that at
> least some kind of indication for this should be available.
You mean like the tcp_keepalives_idle option?
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2006-01-08 16:58:45 | Re: plperl vs LC_COLLATE (was Re: Possible savepoint bug) |
| Previous Message | Andrew Dunstan | 2006-01-08 15:52:30 | Re: plperl header fix and rationalisation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-08 19:20:09 | Re: Change BgWriterCommLock to spinlock |
| Previous Message | Qingqing Zhou | 2006-01-08 16:08:50 | Change BgWriterCommLock to spinlock |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vimal.gupta | 2006-01-08 17:34:30 | Hanging Query |
| Previous Message | David Lang | 2006-01-07 01:18:48 | Re: help tuning queries on large database |