-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 3/7/2012 2:42 PM, Tom Lane wrote:
> Larry Rosenman writes:
>> On 3/7/2012 12:31 PM, Alvaro Herrera wrote:
>>> Also, this isn't limited to CLUSTER; anything that rewrites
>>> the table and indexes would benefit. Meaning ALTER TABLE that
>>> does a
Larry Rosenman writes:
> On 3/7/2012 12:31 PM, Alvaro Herrera wrote:
>> 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
-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
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 CLU
On Wed, Mar 7, 2012 at 9:33 AM, Larry Rosenman wrote:
>>> Is there any way to get more info out of CLUSTER VERBOSE so it
>>> says what index it's working on AFTER the table re-write?
>>>
>>> INFO: clustering "public.values" using sequential scan and sort
>>> INFO: "values": found 0 removable, 26
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 3/6/2012 8:32 AM, Robert Haas wrote:
> On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman
> wrote:
>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1
>>
>> Is there any way to get more info out of CLUSTER VERBOSE so it
>> says what index it's working on
On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Is there any way to get more info out of CLUSTER VERBOSE so it says
> what index it's working on AFTER the table re-write?
>
> INFO: clustering "public.values" using sequential scan and sor
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there any way to get more info out of CLUSTER VERBOSE so it says
what index it's working on AFTER the table re-write?
INFO: clustering "public.values" using sequential scan and sort
INFO: "values": found 0 removable, 260953511 nonremovable row
ve
