PDA

View Full Version : Database slowed by Defrag or Vacuum (weird)



Ballcup
01-18-2010, 04:22 PM
Hi there,
This is the second time I have imported a massive amount of hands to a new computer. When I first finish the import, loading the entire database in the reports tab loads fairly quickly. However, after I vacuum and degrag (turned postgres off), loading the database takes FOREVER. I thought these steps were suppose to speed things up?

Also, I was unable to purge observed hands when I tried. I was getting an error message telling me to increase some value but I dont know how to do that. I will get the exact error message if needed. Thank you!

Patvs
01-18-2010, 06:42 PM
Check out the other top 10 performance tips in the thread in my signature.

Especially editing postgresql.conf, also reindexing the DB

Ballcup
01-18-2010, 08:44 PM
Check out the other top 10 performance tips in the thread in my signature.

Especially editing postgresql.conf, also reindexing the DB

How exactly do I edit the shared buffer/cache size in that postgres config file? I tried right clicking it and going to properties but that didnt have any options.

Patvs
01-18-2010, 08:58 PM
Open it with notepad