Received: from send104.yahoomail.com (send104.yahoomail.com [205.180.60.122]) by hub.org (8.9.2/8.9.1) with SMTP id NAA87371 for ; Thu, 28 Jan 1999 13:57:05 -0500 (EST) (envelope-from tim_perdue@yahoo.com) Message-ID: <19990128184602.21563.rocketmail@send104.yahoomail.com> Received: from [204.167.169.69] by send104.yahoomail.com; Thu, 28 Jan 1999 10:46:02 PST Date: Thu, 28 Jan 1999 10:46:02 -0800 (PST) From: Tim Perdue Reply-To: tim@dmcity.net Subject: Auto-Vacuum? To: pgsql-sql@hub.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Just curious if anyone has written an vacuum shell script. At this point, I have been going in weekly and issuing the VACUUM; command manually. Now that tons of records are being inserted hourly, I want to vacuum 1-2 times a day. I could do this pretty easily with a simple Java/JDBC proram, but would rather just have a shell script go into psql. Unfortunately, I know nothing about shell scripting. Any tips or samples are appreciated. Tim == ______________________________________________________ Tim Perdue tim@perdue.net _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com