You'll probably want to familiarize yourself with the VACUUM command and VACUUMDB utility:
http://www.postgresql.org/idocs/index.php?sql-vacuum.html http://www.postgresql.org/idocs/index.php?app-vacuumdb.html -Andy > -----Original Message----- > From: Ric Manalac [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 25, 2001 10:45 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: postgres optimization > i'd like to ask anyone who have worked with PostgreSQL > for any advise on how to optimize its performance. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]