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

Re: cluster-operation successfull?

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: William ShatnerDate: 2005-05-18 10:40:53
Subject: Storing/Using Passwords
Previous:From: Timo RoessnerDate: 2005-05-17 18:52:41
Subject: cluster-operation successfull?

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