Re: CLUSTER. (fwd) - Mailing list pgsql-general

From Dariusz Pietrzak
Subject Re: CLUSTER. (fwd)
Date
Msg-id Pine.LNX.4.10.10106151747360.30177-100000@ajax.umcs.lublin.pl
Whole thread Raw
Responses Re: CLUSTER. (fwd)  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
> It's done with CLUSTER indeed. Everything is copied in a temp table which is later renamed to the original table, so
allgrant perimissions and indeces are lost on this table. Also keep in mind that you'll get new OIDs too (if you are
dependingon 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?



pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: OT: Apache::Session::DBI vs postgresql? --help
Next
From: Dariusz Pietrzak
Date:
Subject: Re: CLUSTER.