Please do not simply repost your obscure and almost meaningless original question. Please respond to the earlier posts asking for more information. People might be willing to help, but they can't unless you respond to them. Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of roopa perumalraja Sent: Tue 10/17/2006 9:49 PM To: pgsql-general@xxxxxxxxxxxxxx Cc: Subject: [GENERAL] Postgres Database Slow Hi Currently my database size is 38GB and it is pretty slow in whatever I do with it like take a backing up, vaccuming, reindexing, running all queries. Why is that? Is it possible to improve the performance. Thanks in advance Roopa --------------------------------- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. ------------------------------------------------------- Click link below if it is SPAM gsw@xxxxxxxxxxxxxxxx "https://mailscanner.globexplorer.com/dspam/dspam.cgi?signatureID=4535b0a088521470421014&user=gsw@xxxxxxxxxxxxxxxx&retrain=spam&template=history&history_page=1" !DSPAM:4535b0a088521470421014! -------------------------------------------------------