From: | Timo Roessner <timo(dot)roessner(at)gmx(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: cluster-operation successfull? |
Date: | 2005-05-18 11:52:15 |
Message-ID: | 428B2C6F.4060006@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
thx for the help so far, but i am not quite sure if i understood the
answer, scince i am not that experienced in using
postgreSQL.
what means:
select indrelid::regclass, indexrelid::regclass from pg_index
where indisclustered;
?
what is the meaning of "indexrelid" and "regclass"?
i assume "indisclustered" means "indexisclustered", is this a
system-wide variable?
best regards...
Tom Lane wrote:
>Timo Roessner <timo(dot)roessner(at)gmx(dot)net> writes:
>
>
>>scince i didnt receive a success message from the cluster-operation i am
>>not quite sure wether the data was clustered at all
>>or wether the cluster-operation was canceled when the ssh-connection was
>>canceled.
>>is there a way to determine wether data was clustered or not?
>>
>>
>
>Look in the pg_index catalog to see which indexes are marked as
>clustered. In recent PG versions something like this is the easiest
>way:
>
>select indrelid::regclass, indexrelid::regclass from pg_index
>where indisclustered;
>
>I would expect the server to have finished out the command it was
>currently working on before noticing the loss of connection, so
>the odds are good that the cluster did finish.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Schuhmacher, Bret | 2005-05-18 12:58:04 | Psql bug on Windows or pilot error? ;-) |
Previous Message | Sean Davis | 2005-05-18 11:51:15 | Re: Storing/Using Passwords |