Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03758; Sat, 30 Oct 93 23:52:15 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9310310652.AA03758@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: aoki
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03746; Sat, 30 Oct 93 23:52:01 -0700
Message-Id: <9310310652.AA03746@postgres.Berkeley.EDU>
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: PostGres <postgres@st.nepean.uws.edu.au>
Cc: postgres@postgres.berkeley.edu (PostGres Mail Group)
Subject: Re: Expanding pg_time table 
In-Reply-To: Your message of Thu, 28 Oct 1993 01:46:54 +1000 (EST) 
	     <199310271546.AA28762@guinevere.st.nepean.uws.edu.au> 
Date: Sat, 30 Oct 93 23:52:00 PDT
X-Sender: aoki
Resent-To: postgres-dist
Resent-Date: Sat, 30 Oct 93 23:52:13 PDT

> 1st :  how do I reduce the size of the pg_time table
>        in the ~/data directory .. this file is now
>        approaching 2megs and since I dont really know
>        what its used for I thought it best to ask. This
>        also goes for the pg_log file.

currently there's no way to do this.

> 2nd :  The system occasionally produces temp files in
>        the ~/data/base/user database directories. What
>        are these files for and is it ok to delete them.

if there aren't any transactions running (ie, they're really
old files) it should be fine to nuke them.

> 3rd :  My system does not allow me to purge any of the
>        classes. It also falls over with the error 
>        mentioned in the man entry. Has this been fixed
>        or is it something Im doing wrong.

purge broke in 4.1.  it's on the bug list but you'd have to ask
marc (@postgres) if it will be fixed in 4.2.
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki