Search the Knowledgebase

[Advanced Search]

Browse by Category

You don't have permission to add article in this category. Try logging in, or if you think this is an error please contact your administrator.

View Articles by Category

There are no sub categories


Add an article to this category

Category » PostgreSQL Maintenancerss button

PostgreSQL Maintenance

There were 6 articles found in this category:

  1. questionVacuum Analyze Database
    See this FAQ for the automatic vacuum solution we added to the 1.11.04 build on 8/11/2010 http://faq.holdemmanager.com/questions/437/Postgres+Optimization If you want to do it manually, read below. Overview: (Options/Vacuum Analyze Database) Holdem Manager may ask you to run a Vacuum on you ...
  2. questionDatabase 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. questionAdvanced 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 ...
  4. questionMove 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 ...
  5. questionPostgres Optimization
    Overview: Is there an easy way to optimize my postgreSQL database? Yes, there's two tools we've added to help you with this: Optimization - Vacuum/Reindex/Analyze Tuning - Scans PC Hardware and updates PostgreSQL config file To get to these options, click Options/Database Management inside of ...
  6. questionHoldem Manager Performance & Speed Tweaks
    Overview: The following are tips and solutions to performance and speed related issues. Even if you don't have these issue's many of the these suggestions can keep your database running efficiently. NB: Some of these procedures are for advanced users only, don't try any procedures that you&rsqu ...