I started this about a few hours ago (I guess the message shows as a general warning)..I am only interested in the specific database..will this command NOT do a full vacuum of the specific database(I would like to save the few hours that I invested in this vacuum command if possible)
-----Original Message----- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 10:35 AM To: Sriram Dandapani Cc: Tom Lane; [email protected] Subject: Re: [ADMIN] transactoin id wraparound problem Change the -f to -a On Wed, 2006-09-06 at 11:02, Sriram Dandapani wrote: > I created a super user using the createuser command and issued > > vacuumdb -f -U superuser <database-name> > > I still keep getting a decreasing transaction count warning. Am I doing > something wrong here.(The database is about 120G and while I do expect > vacuum full to take time, I expect the warning to show an increasing > count) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
