Received: from send1e.yahoomail.com (send1e.yahoomail.com [205.180.60.64]) by hub.org (8.9.1/8.9.1) with SMTP id JAA16172 for ; Thu, 5 Nov 1998 09:09:41 -0500 (EST) (envelope-from cuda_fx@yahoo.com) Message-ID: <19981105140614.3351.rocketmail@send1e.yahoomail.com> Received: from [208.135.152.110] by send1e; Thu, 05 Nov 1998 06:06:14 PST Date: Thu, 5 Nov 1998 06:06:14 -0800 (PST) From: Barracuda Subject: Updating database To: pgsql-sql@postgreSQL.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Please help:) We have a knowledge base that needs updated every night from a large text file. Currently a script deletes everything from a table and adds the new data. This procedure seems to slowly cause the database to loose performance daily. It also leaves our database useless for several hours starting at midnight. I thought about using 2 databases, updating one while using the other, then swapping them every day. I also thought about having one db.out, then the other in. Is there a better way to do this? Thanks in advance. Charles Day _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com