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
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
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