| From: | Casey Duncan <casey(at)pandora(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Larry Rosenman <lrosenman(at)pervasive(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] autovacuum "connections" are hidden |
| Date: | 2006-05-22 21:45:30 |
| Message-ID: | E85F55BD-D8E0-416C-8C0E-46FC4BA04575@pandora.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On May 22, 2006, at 2:37 PM, Alvaro Herrera wrote:
> Jim C. Nasby wrote:
>> Moving to -hackers
>
> You forgot to actually do it apparently?
>
> Sorry about posting the patch to -general, BTW. Anyway it was
> committed
> to the 8.1 branch, so it is included in the new release (8.1.4?)
>
>> Does this still obey stats_command_string?
>
> Yes.
>
> I considered having the ps display show the info, but it's not as
> useful
> because you can only get the info if you have access to the process
> list
> (i.e. not a remote client).
It would be useful for dba's watching the box directly, via ps or top
(which I find myself doing fairly often). This has always been a
great feature of postgres IMO. I'd put in a vote for having that for
that for the autovac backend as well FWIW.
In any event thanks a lot for the current fix, as is it's a big
improvement! 8^)
-Casey
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-05-22 21:55:50 | Re: allow LIMIT in UPDATE and DELETE |
| Previous Message | Jim C. Nasby | 2006-05-22 21:43:41 | Re: ALTER SEQUENCE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2006-05-22 21:51:56 | Re: Porting MSSQL to PGSQL: trace and profile |
| Previous Message | Alvaro Herrera | 2006-05-22 21:37:03 | Re: [GENERAL] autovacuum "connections" are hidden |