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

Re: CLUSTER removing index from table?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CLUSTER removing index from table?
Date: 2000-08-25 02:15:50
Message-ID: 200008250215.WAA20967@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Known problem with CLUSTER.  See CLUSTER manual page.

> Has anyone else seen this sort of behaviour?  After my CLUSTER command
> my other index has vanished!  I know someone mentioned they had done a
> lot of work on CLUSTER, so perhaps this has been fixed.
> 
> I'm running Debian 7.0.2-4, on i386.
> 
> Regards,
> 					Andrew.
> 
> newsroom=# \d codetable
>         Table "codetable"
>   Attribute  |  Type   | Modifier 
> -------------+---------+----------
>  table_id    | text    | not null
>  code        | text    | not null
>  seq         | integer | 
>  description | text    | 
>  misc        | text    | 
> Indices: codetable_pkey,
>          xak1_codetable
> 
> newsroom=# CLUSTER xak1_codetable ON codetable;
> CLUSTER
> newsroom=# \d codetable
>         Table "codetable"
>   Attribute  |  Type   | Modifier 
> -------------+---------+----------
>  table_id    | text    | 
>  code        | text    | 
>  seq         | integer | 
>  description | text    | 
>  misc        | text    | 
> Index: xak1_codetable
> 
> --
> _____________________________________________________________________
>             Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
> Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
> Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-08-25 02:46:00
Subject: Re: AW: How Do You Pronounce "PostgreSQL"?
Previous:From: Andrew McMillanDate: 2000-08-25 00:49:10
Subject: CLUSTER removing index from table?

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