The Snapper
01-11-2010, 10:52 AM
Sadly I possess only rudimentry skills in the tech department so apologies for any stupid questions.
My postgres version is 1.8.4, is this the latest version.
My database has slowed lately, doesn't retrieve data as quickly now, not really slow but a delay of upto 30 secs. I have done some maintenance periodically ie; vacuum and back up, what should I be doing as standard maintenance and how often?
I noticed recently and dont know if its always been the case but I have a user a/c on my pc called postgres is this correct. My OS is XP professional.
My postgres version is 1.8.4, is this the latest version.
My database has slowed lately, doesn't retrieve data as quickly now, not really slow but a delay of upto 30 secs. I have done some maintenance periodically ie; vacuum and back up, what should I be doing as standard maintenance and how often?
I noticed recently and dont know if its always been the case but I have a user a/c on my pc called postgres is this correct. My OS is XP professional.