Skip site navigation (1) Skip section navigation (2)

Re: cluster-operation successfull?

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: (view raw, whole thread or download thread mbox)
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

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 
>>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
>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?

In response to

pgsql-novice by date

Next:From: Schuhmacher, BretDate: 2005-05-18 12:58:04
Subject: Psql bug on Windows or pilot error? ;-)
Previous:From: Sean DavisDate: 2005-05-18 11:51:15
Subject: Re: Storing/Using Passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group