_Loki_
03-24-2010, 01:02 PM
I was thinking that some of the DB problems I've seen in this forum are due to postgreSQL not being maintained. I was looking around the www today & discovered that if a busy DB isn't maintained the old data can become corrupt - I hadn't realised that could happen. I thought the performance dropped & dropped & that was the end of it...
In FAQ 89:
FAQ - Hold'em Manager Poker Tracking Software :: Advanced PostgreSQL Tuning (http://faq.holdemmanager.com/questions/89/Advanced+PostgreSQL+Tuning)
I found this link:
5-Minute Introduction to PostgreSQL Performance (http://www.westnet.com/%7Egsmith/content/postgresql/pg-5minute.htm)
In that link I found this link:
PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: Routine Vacuuming (http://www.postgresql.org/docs/current/interactive/routine-vacuuming.html)
In section 23.1.5 'The Autovacuum Daemon' I understand it to say that there is an option (or add-on) to maintain the postgreSQL DB with little user intervention
Does anyone know how to do this or is already doing it ?
Is it a good thing ?
Can maintenance occur while playing poker ? (not quite the same thing, but i know you can set some defrag utilities to always be 'on' & they do the defrag in periods of low disk activity)
In FAQ 89:
FAQ - Hold'em Manager Poker Tracking Software :: Advanced PostgreSQL Tuning (http://faq.holdemmanager.com/questions/89/Advanced+PostgreSQL+Tuning)
I found this link:
5-Minute Introduction to PostgreSQL Performance (http://www.westnet.com/%7Egsmith/content/postgresql/pg-5minute.htm)
In that link I found this link:
PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: Routine Vacuuming (http://www.postgresql.org/docs/current/interactive/routine-vacuuming.html)
In section 23.1.5 'The Autovacuum Daemon' I understand it to say that there is an option (or add-on) to maintain the postgreSQL DB with little user intervention
Does anyone know how to do this or is already doing it ?
Is it a good thing ?
Can maintenance occur while playing poker ? (not quite the same thing, but i know you can set some defrag utilities to always be 'on' & they do the defrag in periods of low disk activity)