From: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
---|---|
To: | Leonardo Francalanci <m_lists(at)yahoo(dot)it> |
Cc: | Josh Kupershmidt <schmiddy(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: I: About "Our CLUSTER implementation is pessimal" patch |
Date: | 2010-09-01 09:51:16 |
Message-ID: | AANLkTin63cq5KJtoNrUZd53v7xr0G7MOZZLhFS59BP-q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Aug 31, 2010 at 8:04 PM, Itagaki Takahiro
<itagaki(dot)takahiro(at)gmail(dot)com> wrote:
> * How to determine which method was used?
> We can get some information from trace_sort logs,
> but CLUSTER VERBOSE would be better to log
> which CLUSTER method was used.
I wrote a patch to improve CLUSTER VERBOSE (and VACUUM FULL VERBOSE).
The patch should be applied after sorted_cluster-20100721.patch .
* clustering "schema.table" by index scan on "index"
* clustering "schema.table" by sequential scan and sort
It also adds VACUUM VERBOSE-like logs:
INFO: "table": found 1 removable, 100001 nonremovable row versions in
1655 pages
DETAIL: 1 dead row versions cannot be removed yet.
CPU 0.03s/0.06u sec elapsed 0.21 sec.
Note that the patch says nothing about reindexing. But if
required, I'm willing to add some VERBOSE messages for
indexes (ex. REINDEX VERBOSE)
--
Itagaki Takahiro
Attachment | Content-Type | Size |
---|---|---|
cluster_verbose-20100901.patch | application/octet-stream | 9.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2010-09-01 10:23:56 | Re: Synchronous replication - patch status inquiry |
Previous Message | KaiGai Kohei | 2010-09-01 08:37:57 | Re: leaky views, yet again |