I am fairly newbie to Postgresql and need to have the following done.
---- There have been a lot of data loads onto one of the databases and has resulted in some of the day to day queries to become very slow.
I would like to perhaps Analyze the tables in this database as well as maybe rebuild the indexes (not sure on whether this is the right thing to do exactly)
Can someone please assist me on how to do this and whether / how this can perhaps be scheduled to be done every so often.
