Re: CLUSTER VERBOSE (9.1.3)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 3/7/2012 12:31 PM, Alvaro Herrera wrote:
>
> Excerpts from Robert Haas's message of mié mar 07 11:57:41 -0300
> 2012:
>
>> Seems like a good enhancement to me, if someone can figure out
>> how to do it cleanly. Unfortunately those debug messages may not
>> be in a place where it's real easy for them to know whether
>> they're being called from CLUSTER VERBOSE or not, so it might
>> take a little thought to produce a clean patch for this.
>
> Another thing that occured to me in this general area was whether
> it'd be useful to do something with ps_status and
> pg_stat_activity.
>
> Also, this isn't limited to CLUSTER; anything that rewrites the
> table and indexes would benefit. Meaning ALTER TABLE that does a
> full rewrite, and also VACUUM FULL.
>
+1. I think we should update ps_status as well as pg_stat_activity as
all of these table rewrite processes are running.

Do I need to cogitate on the code, or is one of the hackers that knows
it better interested?

Thanks!

- --
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPV64WAAoJENC8dtAvA1zmItsH/ib0uAh3Jqy6WKXrxBrJoy5k
LBj/xfAs8Z3Xl0TQjoulgAgBV1NWo5DyKvvtmcxpEw1KkJZrpkWONB3I+Y3nQKiy
rfD3uJ6tWvoD9Ay+InPy0W8qReTSKSSI09au60OzU8Ez3UX5JEGhiibn1B6AvXKy
5JWGRJF64fKEnDOresVHqGGhlLM3lelsS7nMX0rs8kZ20BG3tLPjqZslm/qZ3w9M
OJJpJKOlZCoNs+YZTtNxGeRhKXWSfsao6tYc/8To7pbJ6m9MKyqcou7g8yJXZrJr
+BFwPyRG+/p6Li0tWmsuD8FtuPFFp37HxeduKzJNN9sqA3TSeadN8kZweb8zak8=
=jrEi
-----END PGP SIGNATURE-----