Re: [ADMIN] pg_dump/pg_restore

2004-01-12 Thread John Siracusa
On 1/12/04 11:17 AM, Sai Hertz And Control Systems wrote: > Dear Alexey Bobkov , >> Then a try to restore my data: >> pg_restore /path_to_database/backup/db_backup.file >> and get next error >> pg_restore: [archiver] input file does not appear to be a valid archive > > Use psql instead with comman

Re: [ADMIN] Incremental clustering?

2004-01-05 Thread John Siracusa
On 1/4/04 6:24 PM, Christopher Browne wrote: > The cluster operation potentially has to reorder all the tuples, and > the fact that the table is already _partially_ organized only > diminishes the potential. If the new data, generally added "at the > end," has values that are fairly uniformly dist

[ADMIN] Incremental clustering?

2004-01-04 Thread John Siracusa
The docs say: "Clustering is a one-time operation: when the table is subsequently updated, the changes are not clustered. That is, no attempt is made to store new or updated rows according to their index order. If one wishes, one can periodically recluster by issuing the command again." and "Dur