Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06097; Thu, 2 Jul 92 05:32:18 -0700
Date: Thu, 2 Jul 92 05:32:18 -0700
Message-Id: <9207021232.AA06097@postgres.Berkeley.EDU>
From: mstacy@mayo.EDU (Mahlon Stacy  4-4558)
Subject: out of free buffers - how to fix?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

I have an application in which I wish to replace the data in the
database nightly. My plan was to use delete to empty the database,
then copy to load the new information.

When I try to delete I get:

route66% monitor imageindex
Welcome to the C POSTGRES terminal monitor

Go 
* delete FILE \g

Query sent to backend is "delete FILE "
WARN:Jul  2 07:29:36:out of free buffers: time to abort !

Is there a workaround or better suggestion for this?

	-Mahlon
-------------------------------------------------------------
Mahlon Stacy                   Internet:   mcs@mayo.edu
Mayo Foundation                Amateur:    KF0AW
Rochester, MN 55905            Medical Science Bldg 1-29
(507) 284-4558                 FAX (507) 284-1428
-------------------------------------------------------------