Re: indisclustered and clusterdb - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: indisclustered and clusterdb
Date
Msg-id 20020906215749.5215ba2d.alvherre@atentus.com
Whole thread Raw
In response to Re: indisclustered and clusterdb  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: indisclustered and clusterdb
Re: indisclustered and clusterdb
List pgsql-patches
En Mon, 02 Sep 2002 21:14:01 -0400
Tom Lane <tgl@sss.pgh.pa.us> escribió:

> BTW, clusterdb is not schema-aware and will surely fail in any database
> where more than one schema is in use, because it doesn't trouble to
> schema-qualify table names.

Ok, the following patch should solve this concern.  It also tries to
connect as little times as possible (the previous one would connect one
time per table plus one per database; this one connects two times per
database).

It's ugly and has the same concurrency problems that arose for the
original CLUSTER ALL patch, but I don't think there's a clean way to
solve them in a shell script.  Maybe an indication should be put in
clusterdb.sgml that it should run separate from standard CLUSTER
operations or from other runs of clusterdb?

Sorry this took so long.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"There was no reply" (Kernel Traffic)

Attachment

pgsql-patches by date:

Previous
From: Joe Conway
Date:
Subject: contrib/intarray regression failure fix
Next
From: Joe Conway
Date:
Subject: Re: [HACKERS] About connectby()