Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA14913; Thu, 13 Feb 92 09:12:52 -0800
Date: Thu, 13 Feb 92 09:12:52 -0800
Message-Id: <9202131712.AA14913@postgres.Berkeley.EDU>
From: worth@cns.bu.edu
Subject: Sorting
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

We use the following commands to sort a class.  Is this way
appropriate and/or is there a more efficient way?

The class of interest is called 'scan', a backup of this is called
'bscan', and a temporary version of this is 'tscan':

	retrieve into tscan (scan.all) sort by key1, key2
	destroy bscan
	rename scan to bscan
	rename tscan to scan

I ask this question because sometimes it seems that this procedure
gets interrupted and leaves garbage around (this sorting procedure is
executed at 3:00am every day-- after a vacuum at midnight).

Thanks,

Andy. (worth@cns.bu.edu)