From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Timo Roessner <timo(dot)roessner(at)gmx(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: cluster-operation successfull? |
Date: | 2005-05-17 19:42:32 |
Message-ID: | 1978.1116358952@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | William Shatner | 2005-05-18 10:40:53 | Storing/Using Passwords |
Previous Message | Timo Roessner | 2005-05-17 18:52:41 | cluster-operation successfull? |