Category » PostgreSQL Maintenance

There were 4 articles found in this category:

1. Vacuum Analyze Database
   Overview: (Options/Vacuum Analyze Database) Holdem Manager may ask you to run a Vacuum on your database. Doing this frees up disk space and allows your database to run faster. Quick Tip: Vacuuming your database is like getting your car's engine serviced. Manual Vacuum Solution: ...
2. Database Management
   Overview: There are a few things you can do to speed up your database. Only do these procedures when you are experiencing a slow database. (If it ain't broke, don't fix it) Vacuum Analyze Database: You can do two types of Vacuums. Manual Vacuum Simple Vacuum - Click Options / Vacuum An ...
3. Move Database to Another Hard Drive or Partition
   Overview: How do I move my PostgreSQL database (Hand Database) to a new Hard Drive or Drive Partition? Solution: If you have PostgreSQL installed on the C drive where Windows is installed, but you want to move the Data folder i.e Database to a different partition or external hard drive to recl ...
4. Advanced PostgreSQL Tuning
   Overview: Is there anything I can do to speed up my PostgreSQL? Note: Advanced PC Users only!!! Solution: We came across the following post on 2+2 about how to speed up PostgreSQL. Note: (Use at your own risk) Find your postgresql.conf file and open in notepad. Mine was in C:\Pr ...