Re: CLUSTER. (fwd)

From: Dariusz Pietrzak <dariush(at)ajax(dot)umcs(dot)lublin(dot)pl>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CLUSTER. (fwd)
Date: 2001-06-15 15:49:16
Message-ID: Pine.LNX.4.10.10106151747360.30177-100000@ajax.umcs.lublin.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> It's done with CLUSTER indeed. Everything is copied in a temp table which is later renamed to the original table, so all grant perimissions and indeces are lost on this table. Also keep in mind that you'll get new OIDs too (if you are depending on them)
Is very any way of going cluster without losing anything?
At this point I am able to dump/restore database, but soon it'll become
rather impossible for some time.
Do I have to 'cluster' before putting any data in dbase?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-06-15 15:59:40 Re: CLUSTER. (fwd)
Previous Message Dick Brooks 2001-06-15 15:43:57 How to reference C function parameters from embedded SQL