Raid installed and no performace improvement at housekeeping

[orbit09]

Hello,

this time i have an understanding problem. Since yesterday i had a only one hdd. To get a performance improvement value i housekept my 4 databases two times. The first time should be to create a situation to compare the time which is needed for housekeeping the databases. The second time the housekeeping need 71 minutes.
Then i have installed a raid 0 system with two disk. My test with hd tunes shows, that the raid system is much more quicker the the single disk (up to 2.5 times). Now i have expected, that when i transfer the databases to the raid system then the housekeeping process will work much faster.
To do this transfer, i have done the steps http://www.pokertracker.com/forums/arch ... postgresql.
When i try the housekeeping with raid systems, then it take the same time.

Is it normal ?
How can i test the efficency of the new installation ? I have a complete backup of my original system, so i ´m able to go back to the old installation and try other tests.

Thank for your help

[kraada]

That's odd - which housekeeping functions were you running?

[orbit09]

Database/Housekeeping Vacuum, Analyse, Update Cache and Cluster

[kraada]

With a RAID array you won't need to cluster - cluster rearranges the data on your hard drive to make it physically easier to access. I'm not sure how that is going to interact with the RAID setup - and probably what's easiest is to simply not bother. Your query times should be noticibly faster with the new setup - you can see your query times in the PokerTracker.log file that is created in the C:\Program Files\PokerTracker 3\ directory when you start PT3 using the logging enabled link.

[orbit09]

Thanks.

Then i the test with logging enabled in both enviroments and i think i can give a feedback tomorrow.

[kraada]

Thanks, I look forward to the results.

[orbit09]

Hello,

the test is done and i have checked both Poker Tracker logfile and found only marginal spped differences.
Here are the log extract, because i can not attach the files.
At file import i found some speed increasing, but i´m not sure if this is permanent. (One disk installation 70h/s, Raid installation 107h/s)

Database on raid system

2010/06/20 13:00:39.904: [00001790][ThreadPool] New thread created
2010/06/20 13:00:39.932: [00001790][Query::QueryThread] Thread [0x00001790]: Begin
2010/06/20 13:00:39.935: [00001790][Query] Connecting to database: Pokerstars_2010
2010/06/20 13:00:39.936: [00001790][Query] Executing SQL (Thread): SELECT player.id_player, player.id_site, player.player_name, player.val_icon FROM player WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2010/06/20 13:00:40.157: [00001790][Query] Query execution time: 219.42202151 ms :
2010/06/20 13:00:40.311: [00001790][QueryReportCtrl::Populate] Thread [0x00001790]: Begin
2010/06/20 13:00:40.876: [00001790][QueryReportCtrl] Query 1: Populate: 564.6084 ms, 3119 rows, 6 cols, 0.0302 ms/col (time log: Query 1: t0: 3.1130 ms, t1: 11.0670 ms, t2: 550.3040 ms, t3: 0.0031 ms, t4: 0.0609 ms, t5: 0.0089 ms, t6: 0.0036 ms)
2010/06/20 13:00:47.833: [- Main -][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries//.xml
2010/06/20 13:00:56.592: [00001790][Query::QueryThread] Thread [0x00001790]: Begin
2010/06/20 13:00:56.592: [00001790][Query] Connecting to database: Pokerstars_2010
2010/06/20 13:00:56.594: [00001790][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 13:01:02.679: [00001790][Query] Query execution time: 6084.92755364 ms :
2010/06/20 13:01:02.884: [00001790][QueryReportCtrl::Populate] Thread [0x00001790]: Begin
2010/06/20 13:01:17.719: [00001790][QueryReportCtrl] Query 2: Populate: 14833.6266 ms, 25470 rows, 13 cols, 0.0448 ms/col (time log: Query 2: t0: 0.0450 ms, t1: 85.6830 ms, t2: 14355.5203 ms, t3: 0.0028 ms, t4: 0.2956 ms, t5: 335.4549 ms, t6: 56.4650 ms)
2010/06/20 13:01:23.313: [00001790][Query::QueryThread] Thread [0x00001790]: Begin
2010/06/20 13:01:23.314: [00001790][Query] Connecting to database: Pokerstars_2010
2010/06/20 13:01:23.316: [00001790][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 13:01:29.674: [00001790][Query] Query execution time: 6354.87024189 ms :
2010/06/20 13:01:29.820: [00001790][QueryReportCtrl::Populate] Thread [0x00001790]: Begin
2010/06/20 13:01:45.413: [00001790][QueryReportCtrl] Query 3: Populate: 15588.9821 ms, 25470 rows, 13 cols, 0.0471 ms/col (time log: Query 3: t0: 0.1341 ms, t1: 95.8574 ms, t2: 15168.3382 ms, t3: 0.0028 ms, t4: 0.2925 ms, t5: 322.2496 ms, t6: 2.0103 ms)
2010/06/20 13:02:24.756: [00001790][Query::QueryThread] Thread [0x00001790]: Begin
2010/06/20 13:02:24.757: [00001790][Query] Connecting to database: Pokerstars_2010
2010/06/20 13:02:24.760: [00001790][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 13:02:30.850: [00001790][Query] Query execution time: 6089.37448754 ms :
2010/06/20 13:02:31.080: [00001790][QueryReportCtrl::Populate] Thread [0x00001790]: Begin
2010/06/20 13:02:45.795: [00001790][QueryReportCtrl] Query 4: Populate: 14715.4856 ms, 25470 rows, 13 cols, 0.0444 ms/col (time log: Query 4: t0: 0.0450 ms, t1: 86.4305 ms, t2: 14257.1548 ms, t3: 0.0031 ms, t4: 0.3037 ms, t5: 369.4780 ms, t6: 1.9698 ms)
2010/06/20 13:03:04.891: [- Main -][WindowMain] Setting active database to: Observed_2010
2010/06/20 13:03:04.894: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 13:03:05.008: [- Main -][PostgresConnection] [0x0bdf60c0] Successfully connected to: Observed_2010 [210275792] (PostgreSQL version 80304)
2010/06/20 13:03:05.363: [- Main -][ConnectionManager] Database Version: 300039
2010/06/20 13:03:05.375: [- Main -][PostgresConnection] [0x05e00b90] Disconnecting from database: Pokerstars_2010
2010/06/20 13:03:05.375: [- Main -][PostgresConnection] [0x05dfd240] Disconnecting from database: Pokerstars_2010
2010/06/20 13:03:05.376: [- Main -][PostgresConnection] [0x05dfe090] Disconnecting from database: Pokerstars_2010
2010/06/20 13:03:05.376: [- Main -][PostgresConnection] [0x05df32c0] Disconnecting from database: Pokerstars_2010
2010/06/20 13:03:05.379: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 13:03:05.487: [- Main -][PostgresConnection] [0x05df5280] Successfully connected to: Observed_2010 [98520528] (PostgreSQL version 80304)
2010/06/20 13:03:05.498: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 13:03:05.594: [- Main -][PostgresConnection] [0x05df5120] Successfully connected to: Observed_2010 [98525312] (PostgreSQL version 80304)
2010/06/20 13:03:05.604: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 13:03:05.706: [- Main -][PostgresConnection] [0x05df6370] Successfully connected to: Observed_2010 [98531232] (PostgreSQL version 80304)
2010/06/20 13:03:05.750: [- Main -][WindowStatsTab] Refreshing active player: false
2010/06/20 13:03:05.846: [- Main -][WindowStatsTab] Refreshing active player: false
2010/06/20 13:03:06.041: [- Main -][WindowMain] Database: Observed_2010 Size: 9296 MB
2010/06/20 13:03:06.382: [- Main -][WindowMain] Database: Observed_2010 Cache Status: Holdem: 100% Holdem Tourney: 100% Omaha Tourney: 100%
2010/06/20 13:03:13.005: [00000834][ImportManual::ImportManualFeeder::Entry] Beginning thread.
2010/06/20 13:03:13.006: [00000834][ImportManual::ImportManualFeeder] Thread [0x00000834]: Begin
2010/06/20 13:03:13.007: [00000834][ImportManual] Message: Import beginning
2010/06/20 13:03:13.101: [00000834][HandHistoryDatabaseImport::DatabaseVariables] Getting connections
2010/06/20 13:03:15.715: [0000130C][HandHistoryDatabaseImport::DatabaseVariables::Entry] Beginning thread.
2010/06/20 13:03:15.716: [0000130C][HandHistoryDatabaseImport::DatabaseVariables] Thread [0x0000130C]: Begin
2010/06/20 13:03:15.723: [00000834][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 13:03:25.373: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 13:03:29.299: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36155)
2010/06/20 13:03:29.411: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36696)
2010/06/20 13:03:31.993: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 13:03:32.222: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #44686)
2010/06/20 13:03:37.188: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 13:03:38.338: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #75636)
2010/06/20 13:03:38.672: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #77181)
2010/06/20 13:03:43.019: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 13:03:44.780: [00000834][ImportManual] Message: + Complete (2,327 hands, 0 errors, 0 duplicates)
2010/06/20 13:03:44.781: [00000834][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125424.txt
2010/06/20 13:03:44.883: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #194)
2010/06/20 13:03:45.666: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #5146)
2010/06/20 13:03:47.550: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #9284)
2010/06/20 13:03:47.697: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #9979)
2010/06/20 13:03:47.901: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #11402)
2010/06/20 13:03:49.327: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #16053)
2010/06/20 13:03:49.520: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #16716)
2010/06/20 13:03:50.416: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125424.txt
2010/06/20 13:03:50.512: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #22730)
2010/06/20 13:03:50.644: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #23390)
2010/06/20 13:03:51.919: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #28651)
2010/06/20 13:03:53.102: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36409)
2010/06/20 13:03:53.106: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36448)
2010/06/20 13:03:53.114: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36521)
2010/06/20 13:03:53.597: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #38136)
2010/06/20 13:03:53.639: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #38609)
2010/06/20 13:03:54.275: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125424.txt
2010/06/20 13:03:55.054: [00000834][ImportManual] Message: + Complete (1,585 hands, 0 errors, 0 duplicates)
2010/06/20 13:03:55.056: [00000834][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 13:04:00.835: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 13:04:05.204: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 13:04:05.953: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #44648)
2010/06/20 13:04:07.659: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #53578)
2010/06/20 13:04:09.112: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #63889)
2010/06/20 13:04:09.378: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 13:04:10.446: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #70407)
2010/06/20 13:04:14.197: [00000834][ImportManual] Message: + Complete (2,364 hands, 0 errors, 0 duplicates)
2010/06/20 13:04:14.199: [00000834][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 13:04:20.423: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 13:04:24.594: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 13:04:28.085: [00000834][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #63573)
2010/06/20 13:04:28.678: [00000834][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 13:04:32.331: [00000834][ImportManual] Message: + Complete (1,998 hands, 0 errors, 0 duplicates)
2010/06/20 13:04:32.332: [00000834][ImportManual] Message: Import complete. 8,274 hands in 4 files were imported. (0 errors, 0 duplicates)
2010/06/20 13:04:32.625: [0000130C][DatabaseVariables::Entry] 0 queries remain.


Original installation on one disk:

2010/06/20 12:51:26.469: [00000BD4][ThreadPool] New thread created
2010/06/20 12:51:26.496: [00000BD4][Query::QueryThread] Thread [0x00000BD4]: Begin
2010/06/20 12:51:26.496: [00000BD4][Query] Connecting to database: Pokerstars_2010
2010/06/20 12:51:26.497: [00000BD4][Query] Executing SQL (Thread): SELECT player.id_player, player.id_site, player.player_name, player.val_icon FROM player WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2010/06/20 12:51:26.678: [00000BD4][Query] Query execution time: 180.22877209 ms :
2010/06/20 12:51:26.908: [00000BD4][QueryReportCtrl::Populate] Thread [0x00000BD4]: Begin
2010/06/20 12:51:27.461: [00000BD4][QueryReportCtrl] Query 1: Populate: 552.7845 ms, 3119 rows, 6 cols, 0.0295 ms/col (time log: Query 1: t0: 0.1352 ms, t1: 10.0669 ms, t2: 542.4516 ms, t3: 0.0031 ms, t4: 0.0673 ms, t5: 0.0092 ms, t6: 0.0036 ms)
2010/06/20 12:51:34.468: [- Main -][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries//.xml
2010/06/20 12:51:39.740: [00000BD4][Query::QueryThread] Thread [0x00000BD4]: Begin
2010/06/20 12:51:39.741: [00000BD4][Query] Connecting to database: Pokerstars_2010
2010/06/20 12:51:39.743: [00000BD4][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 12:51:45.799: [00000BD4][Query] Query execution time: 6056.34822303 ms :
2010/06/20 12:51:45.826: [00000BD4][QueryReportCtrl::Populate] Thread [0x00000BD4]: Begin
2010/06/20 12:52:00.440: [00000BD4][QueryReportCtrl] Query 2: Populate: 14613.7967 ms, 25470 rows, 13 cols, 0.0441 ms/col (time log: Query 2: t0: 5.9664 ms, t1: 86.0366 ms, t2: 14196.5806 ms, t3: 0.0031 ms, t4: 0.2883 ms, t5: 324.8337 ms, t6: 0.0061 ms)
2010/06/20 12:52:10.797: [00000BD4][Query::QueryThread] Thread [0x00000BD4]: Begin
2010/06/20 12:52:10.798: [00000BD4][Query] Connecting to database: Pokerstars_2010
2010/06/20 12:52:10.800: [00000BD4][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 12:52:16.730: [00000BD4][Query] Query execution time: 5929.90533713 ms :
2010/06/20 12:52:16.884: [00000BD4][QueryReportCtrl::Populate] Thread [0x00000BD4]: Begin
2010/06/20 12:52:31.341: [00000BD4][QueryReportCtrl] Query 3: Populate: 14456.1138 ms, 25470 rows, 13 cols, 0.0437 ms/col (time log: Query 3: t0: 0.7864 ms, t1: 86.3082 ms, t2: 14004.6704 ms, t3: 0.0031 ms, t4: 0.3126 ms, t5: 320.9003 ms, t6: 43.0563 ms)
2010/06/20 12:52:36.668: [00000BD4][Query::QueryThread] Thread [0x00000BD4]: Begin
2010/06/20 12:52:36.669: [00000BD4][Query] Connecting to database: Pokerstars_2010
2010/06/20 12:52:36.671: [00000BD4][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 12:52:42.708: [00000BD4][Query] Query execution time: 6035.13351557 ms :
2010/06/20 12:52:42.759: [00000BD4][QueryReportCtrl::Populate] Thread [0x00000BD4]: Begin
2010/06/20 12:52:57.278: [00000BD4][QueryReportCtrl] Query 4: Populate: 14518.8193 ms, 25470 rows, 13 cols, 0.0438 ms/col (time log: Query 4: t0: 6.5765 ms, t1: 86.2962 ms, t2: 14042.7842 ms, t3: 0.0031 ms, t4: 0.2933 ms, t5: 317.8767 ms, t6: 1.9285 ms)
2010/06/20 12:53:31.532: [- Main -][WindowMain] Setting active database to: Observed_2010
2010/06/20 12:53:31.535: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 12:53:31.644: [- Main -][PostgresConnection] [0x0c018510] Successfully connected to: Observed_2010 [201434496] (PostgreSQL version 80304)
2010/06/20 12:53:32.101: [- Main -][ConnectionManager] Database Version: 300039
2010/06/20 12:53:32.121: [- Main -][PostgresConnection] [0x05bf0f40] Disconnecting from database: Pokerstars_2010
2010/06/20 12:53:32.127: [- Main -][PostgresConnection] [0x05bee640] Disconnecting from database: Pokerstars_2010
2010/06/20 12:53:32.127: [- Main -][PostgresConnection] [0x05beda30] Disconnecting from database: Pokerstars_2010
2010/06/20 12:53:32.128: [- Main -][PostgresConnection] [0x05be3a50] Disconnecting from database: Pokerstars_2010
2010/06/20 12:53:32.131: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 12:53:32.275: [- Main -][PostgresConnection] [0x05bee080] Successfully connected to: Observed_2010 [96397536] (PostgreSQL version 80304)
2010/06/20 12:53:32.287: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 12:53:32.394: [- Main -][PostgresConnection] [0x05bee600] Successfully connected to: Observed_2010 [96396032] (PostgreSQL version 80304)
2010/06/20 12:53:32.405: [- Main -][PostgresConnection] Connecting to database: Observed_2010
2010/06/20 12:53:32.529: [- Main -][PostgresConnection] [0x05be3230] Successfully connected to: Observed_2010 [96351648] (PostgreSQL version 80304)
2010/06/20 12:53:32.580: [- Main -][WindowStatsTab] Refreshing active player: false
2010/06/20 12:53:32.697: [- Main -][WindowStatsTab] Refreshing active player: false
2010/06/20 12:53:33.026: [- Main -][WindowMain] Database: Observed_2010 Size: 9296 MB
2010/06/20 12:53:33.208: [- Main -][WindowMain] Database: Observed_2010 Cache Status: Holdem: 100% Holdem Tourney: 100% Omaha Tourney: 100%
2010/06/20 12:53:50.508: [000015A4][ImportManual::ImportManualFeeder::Entry] Beginning thread.
2010/06/20 12:53:50.509: [000015A4][ImportManual::ImportManualFeeder] Thread [0x000015A4]: Begin
2010/06/20 12:53:50.510: [000015A4][ImportManual] Message: Import beginning
2010/06/20 12:53:50.613: [000015A4][HandHistoryDatabaseImport::DatabaseVariables] Getting connections
2010/06/20 12:53:53.108: [000013C4][HandHistoryDatabaseImport::DatabaseVariables::Entry] Beginning thread.
2010/06/20 12:53:53.115: [000013C4][HandHistoryDatabaseImport::DatabaseVariables] Thread [0x000013C4]: Begin
2010/06/20 12:53:53.117: [000015A4][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 12:54:03.783: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 12:54:08.703: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36155)
2010/06/20 12:54:08.864: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36696)
2010/06/20 12:54:11.832: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 12:54:12.064: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #44686)
2010/06/20 12:54:17.980: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 12:54:19.592: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #75636)
2010/06/20 12:54:19.985: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #77181)
2010/06/20 12:54:24.691: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125349.txt
2010/06/20 12:54:27.637: [000015A4][ImportManual] Message: + Complete (2,327 hands, 0 errors, 0 duplicates)
2010/06/20 12:54:27.646: [000015A4][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125424.txt
2010/06/20 12:54:28.108: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #194)
2010/06/20 12:54:29.009: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #5146)
2010/06/20 12:54:31.430: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #9284)
2010/06/20 12:54:31.581: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #9979)
2010/06/20 12:54:31.971: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #11402)
2010/06/20 12:54:34.486: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #16053)
2010/06/20 12:54:34.637: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #16716)
2010/06/20 12:54:35.718: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125424.txt
2010/06/20 12:54:35.824: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #22730)
2010/06/20 12:54:35.963: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #23390)
2010/06/20 12:54:37.104: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #28651)
2010/06/20 12:54:40.012: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36409)
2010/06/20 12:54:40.083: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36448)
2010/06/20 12:54:40.104: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #36521)
2010/06/20 12:54:45.139: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #38136)
2010/06/20 12:54:45.195: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #38609)
2010/06/20 12:54:48.407: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125424.txt
2010/06/20 12:54:51.128: [000015A4][ImportManual] Message: + Complete (1,585 hands, 0 errors, 0 duplicates)
2010/06/20 12:54:51.139: [000015A4][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 12:55:01.228: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 12:55:06.658: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 12:55:07.618: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #44648)
2010/06/20 12:55:09.451: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #53578)
2010/06/20 12:55:11.922: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #63889)
2010/06/20 12:55:12.537: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125447.txt
2010/06/20 12:55:13.811: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #70407)
2010/06/20 12:55:19.340: [000015A4][ImportManual] Message: + Complete (2,364 hands, 0 errors, 0 duplicates)
2010/06/20 12:55:19.343: [000015A4][ImportManual] Message: Import file: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 12:55:35.933: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 12:55:41.265: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 12:55:45.109: [000015A4][ImportManual] Message: Warning: Encountered cancelled hand history. (Line #63573)
2010/06/20 12:55:45.759: [000015A4][HandHistoryFeederText] File Reset: C:\Anwendungsdaten\Pokerstars\Handhistory\20100619125511.txt
2010/06/20 12:55:49.826: [000015A4][ImportManual] Message: + Complete (1,998 hands, 0 errors, 0 duplicates)
2010/06/20 12:55:49.828: [000015A4][ImportManual] Message: Import complete. 8,274 hands in 4 files were imported. (0 errors, 0 duplicates)
2010/06/20 12:55:50.125: [000013C4][DatabaseVariables::Entry] 0 queries remain.

[WhiteRider]

You will likely get a boost in performance if you update to the latest 8.3.x version; 8.3.4 is pretty old now and is known to have problems.
Directions here

[orbit09]

When i try the upgrade.bat as Administrator i get an error message.
An error occured during the installation of assembly. 'policy.8.0.Microsoft.VC80.CRT, publicKeyToken="1fc8b3b9a1e18e3b",type="win32-policy",version="8.0.50727.762",processorArchitecture="x86"

[orbit09]

Now i have installed Postgres 8.3.11 as a new installation, deinstalled 8.3.4 and installed 8.3.11 without initialize database cluster.
Installation successfull and PT found all databases.
Then i try the same test. Results look identical as the first two.

2010/06/20 17:37:26.994: [- Main -][System] PokerTracker v3.06.2
2010/06/20 17:37:26.996: [- Main -][SystemInfo] OS: Windows NT 6.1 (build 7600)
2010/06/20 17:37:26.997: [- Main -][SystemInfo] Windows Version: 6.1 build 7600 (platform 2)
2010/06/20 17:37:26.997: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0407
2010/06/20 17:37:26.998: [- Main -][SystemInfo] Total Physical Processors or Cores: 2
2010/06/20 17:37:26.999: [- Main -][SystemInfo] Processor 1: Speed: 2.00 GHz Name: AMD Athlon(tm) 64 X2 Dual Core Processor 3800+
2010/06/20 17:37:27.008: [- Main -][SystemInfo] Processor 2: Speed: 2.00 GHz Name: AMD Athlon(tm) 64 X2 Dual Core Processor 3800+
2010/06/20 17:37:27.010: [- Main -][SystemInfo] C:\ Disk Space: 479,398 mb total; 173,052 mb used; 306,346 mb free
2010/06/20 17:37:27.011: [- Main -][SystemInfo] D:\ Disk Space: 953,877 mb total; 257,648 mb used; 696,229 mb free
2010/06/20 17:37:27.013: [- Main -][SystemInfo] E:\ Disk Space: 474,368 mb total; 216,554 mb used; 257,814 mb free
2010/06/20 17:37:27.014: [- Main -][SystemInfo] Physical Memory: 2,048 mb (1,477 mb available) Virtual Memory: 2,048 mb (1,952 mb available) Page File: 4,096 mb (4,096 mb available)
2010/06/20 17:37:27.016: [- Main -][System Info] Video[0]: NVIDIA GeForce 6150 (\\.\DISPLAY1)
2010/06/20 17:37:27.018: [- Main -][System Info] Video[1]: NVIDIA GeForce 6150 (\\.\DISPLAY2)
2010/06/20 17:37:27.044: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=454,257\nMainSize=1200,764\nMainMaximized=Y\n\n\n[General]\nLogging=N\nRegistrationCode=*** REG CODE REMOVED ***\nBestHudPerformance=N\nInvalidText=#C0C0C0:NA\nUseCardImages=Y\nColorPositiveText=009900\nColorPositiveRow=EBFFEB\nColorNegativeText=AA0000\nColorNegativeRow=FFEBEB\nBuildDate=2010/04/16\n\n\n[Import]\nBeepOnCompletion=N\nClusterOnCompletion=N\nVacuumOnCompletion=N\nAnalyzeOnCompletion=N\nUpCacheOnCompletion=N\nMoveProcessedFilesDirectory=C:\Program Files\PokerTracker 3\Processed\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nPriority=2\nHidden.1200=Y\nHidden.1300=Y\nHidden.700=Y\nHidden.800=Y\nHidden.1000=Y\nHidden.400=Y\nHidden.1100=Y\nHidden.600=Y\nHidden.900=Y\nHidden.200=Y\nForceSetupWizard=N\nPlayedHandsDatabase=Observed_2010\nObservedHandsDatabase=Observed_2010\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=PokerTracker 3 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT3 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=Pokerstars_2009\nDB2.Type=postgres\nDB2.Postgres.Database=PS_01\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=dbpass\nDB3.Name=Pokerstars_2010\nDB3.Type=postgres\nDB3.Postgres.Database=Pokerstars_2010\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB3.Postgres.Password=dbpass\nDB4.Name=Observed_2010\nDB4.Type=postgres\nDB4.Postgres.Database=Observed_2010\nDB4.Postgres.Server=localhost\nDB4.Postgres.Port=5432\nDB4.Postgres.User=postgres\nDB4.Postgres.Password=dbpass\nDB3.Default=Y\n\n\n[ReportInfo]\n\n\n[HandReplayer]\nShowKnownCards=Y\nShowHeroCards=Y\n\n[Directories]\nBackupDirectory=C:\Anwendungsdaten\tmp\nManualImportFile=C:\Anwendungsdaten\Pokerstars\Handhistory\*ManualImportDirectory=C:\Anwendungsdaten\tmp\PokerStars\nDatabaseExportDirectory=C:\Users\kurt\Documents\poker\tmp\n\*"\n[Messages]\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:1b9775a152c0353de5fd74d94ea1f85c=Y\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:218b96d1c4038f78923963117951eceb=Y\nOptOut:f797b1cf4942ae8efd07f03a31b21636=Y\n[Tabs]\nLast:WindowMain=1\nLast:WindowImport=1\nLast:WindowStats:Holdem=0\nLast:WindowStatsTab:holdem-cash=7\nLast:WindowStatsTab:holdem-tourney=8\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=0\nLast:WindowStatsTab:omaha-tourney=0\n[TableTracker]\nHideTablesNoStats=N\n[Hud]\nPerformanceOption=0\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nNotes.Translucency=20\nMinHands=1\nCurrentLimit=N\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nRefreshRates=0,25,1|25,100,5|100,200,10|200,100000,20|\nDatabases=Pokerstars_2009\nPokerstars_2010\nObserved_2010\nNotesSize=450,152\n[Site.PokerStars]\nHandHistoryDirectory=C:\Anwendungsdaten\Pokerstars\Handhistory\n
2010/06/20 17:37:27.128: [- Main -][System] Getting String: 5CD5-815C-F4E1-1F07-ABD9-3918-51BC-2FF0
2010/06/20 17:37:27.144: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2010/06/20 17:37:27.146: [- Main -][wxThreadedRead] Starting read thread ...
2010/06/20 17:37:27.148: [00000550][ConnectorReadThread] Thread [0x00000550]: Begin
2010/06/20 17:37:27.149: [00000550][ConnectorReadThread::Entry] Beginning thread.
2010/06/20 17:37:27.150: [- Main -][wxThreadedRead] Waiting for completion ...
2010/06/20 17:37:27.151: [00000550][ConnectorReadThread] Creating socket...
2010/06/20 17:37:27.153: [00000550][ConnectorReadThread] DNS lookup...
2010/06/20 17:37:27.294: [00000550][ConnectorReadThread] Socket connect...
2010/06/20 17:37:28.880: [00000550][ConnectorReadThread] Sending request...
2010/06/20 17:37:29.336: [00000550][ConnectorReadThread] Reading response...
2010/06/20 17:37:29.343: [00000550][ConnectorReadThread] Read complete.
2010/06/20 17:37:29.349: [00000550][ConnectorReadThread] Returning.
2010/06/20 17:37:29.450: [- Main -][wxThreadedRead] Checking for Completion ...
2010/06/20 17:37:29.451: [- Main -][wxThreadedRead] Waiting on the thread ...
2010/06/20 17:37:29.452: [- Main -][wxThreadedRead] Getting data ...
2010/06/20 17:37:29.459: [- Main -][wxThreadedRead] Calling return ...
2010/06/20 17:37:29.483: [- Main -][Registration] License written to C:\Program Files\PokerTracker 3/Data/Config/PokerTracker.lic
2010/06/20 17:37:29.490: [- Main -][System] Registered: true
2010/06/20 17:37:29.504: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2010/06/20 17:37:29.534: [- Main -][WindowSplash] Beginning load process
2010/06/20 17:37:29.539: [000014B4][WindowSplash::Worker::Entry] Beginning thread.
2010/06/20 17:37:29.540: [000014B4][WindowSplash::Worker] Thread [0x000014B4]: Begin
2010/06/20 17:37:29.570: [000014B4][QueryManager] Loading queries
2010/06/20 17:37:29.573: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Aliases.xml.pte
2010/06/20 17:37:29.581: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2010/06/20 17:37:29.641: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2010/06/20 17:37:29.687: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Notes.xml.pte
2010/06/20 17:37:29.698: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2010/06/20 17:37:29.751: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2010/06/20 17:37:29.778: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Players.xml.pte
2010/06/20 17:37:29.791: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2010/06/20 17:37:29.815: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2010/06/20 17:37:29.825: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2010/06/20 17:37:29.848: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2010/06/20 17:37:29.876: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2010/06/20 17:37:29.878: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2010/06/20 17:37:29.892: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2010/06/20 17:37:29.912: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2010/06/20 17:37:29.913: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2010/06/20 17:37:29.928: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2010/06/20 17:37:30.025: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2010/06/20 17:37:30.075: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2010/06/20 17:37:30.086: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2010/06/20 17:37:30.091: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2010/06/20 17:37:30.111: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2010/06/20 17:37:30.116: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2010/06/20 17:37:30.130: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Summary-Site.xml.pte
2010/06/20 17:37:30.143: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2010/06/20 17:37:30.162: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2010/06/20 17:37:30.230: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2010/06/20 17:37:30.278: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2010/06/20 17:37:30.312: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2010/06/20 17:37:30.322: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2010/06/20 17:37:30.345: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2010/06/20 17:37:30.376: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2010/06/20 17:37:30.382: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2010/06/20 17:37:30.396: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2010/06/20 17:37:30.416: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2010/06/20 17:37:30.423: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2010/06/20 17:37:30.438: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2010/06/20 17:37:30.527: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2010/06/20 17:37:30.573: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2010/06/20 17:37:30.583: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2010/06/20 17:37:30.588: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2010/06/20 17:37:30.607: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2010/06/20 17:37:30.610: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2010/06/20 17:37:30.624: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Summary-Site.xml.pte
2010/06/20 17:37:30.636: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2010/06/20 17:37:30.656: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2010/06/20 17:37:30.757: [000014B4][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2010/06/20 17:37:30.804: [000014B4][QueryManager] Queries loaded.
2010/06/20 17:37:30.811: [000014B4][StatManager] Loading stats and reports...
2010/06/20 17:37:35.401: [000014B4][StatManager] Stats and reports loaded.
2010/06/20 17:37:35.403: [000014B4][FilterManager] Loading filters...
2010/06/20 17:37:45.429: [000014B4][FilterManager] Filters loaded.
2010/06/20 17:37:45.434: [000014B4][LayoutManager] Loading layouts...
2010/06/20 17:37:46.047: [000014B4][StatManager] Loading stats and reports...
2010/06/20 17:37:51.213: [000014B4][StatManager] Stats and reports loaded.
2010/06/20 17:37:51.215: [000014B4][LayoutManager] Layouts loaded.
2010/06/20 17:37:51.220: [000014B4][PostgresConnection] Connecting to database: Pokerstars_2010
2010/06/20 17:37:51.390: [000014B4][PostgresConnection] [0x05b432c0] Successfully connected to: Pokerstars_2010 [95702480] (PostgreSQL version 80311)
2010/06/20 17:37:51.416: [000014B4][ConnectionManager] Database Version: 300039
2010/06/20 17:37:51.433: [000014B4][PostgresConnection] Connecting to database: Pokerstars_2010
2010/06/20 17:37:51.637: [000014B4][PostgresConnection] [0x05b4e0d0] Successfully connected to: Pokerstars_2010 [95746480] (PostgreSQL version 80311)
2010/06/20 17:37:51.649: [000014B4][PostgresConnection] Connecting to database: Pokerstars_2010
2010/06/20 17:37:51.789: [000014B4][PostgresConnection] [0x05b4d1f0] Successfully connected to: Pokerstars_2010 [95744912] (PostgreSQL version 80311)
2010/06/20 17:37:51.805: [000014B4][PostgresConnection] Connecting to database: Pokerstars_2010
2010/06/20 17:37:51.963: [000014B4][PostgresConnection] [0x05b50b60] Successfully connected to: Pokerstars_2010 [95749984] (PostgreSQL version 80311)
2010/06/20 17:37:51.976: [000014B4][WindowSplash::Worker::Entry] Ending thread.
2010/06/20 17:37:51.977: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2010/06/20 17:37:51.978: [- Main -][WindowSplash::checkProgress] Worker complete.
2010/06/20 17:37:52.390: [- Main -][PokerStarsOptions] Special Path: C:\Users\kurt\AppData\Local\PokerStars
2010/06/20 17:37:52.396: [- Main -][WPEXOptions] Unable to access registry key
2010/06/20 17:37:52.397: [- Main -][WPEXOptions] Found INI File:
2010/06/20 17:37:52.580: [- Main -][PokerStarsOptions] Special Path: C:\Users\kurt\AppData\Local\PokerStars
2010/06/20 17:37:52.582: [- Main -][PokerStarsOptions] Found INI File: C:\Users\kurt\AppData\Local\PokerStars\user.ini
2010/06/20 17:37:52.768: [- Main -][PokerStarsOptions] Special Path: C:\Users\kurt\AppData\Local\PokerStars
2010/06/20 17:37:52.782: [- Main -][PokerStarsOptions] Special Path: C:\Users\kurt\AppData\Local\PokerStars
2010/06/20 17:37:52.829: [- Main -][PokerStarsOptions] Special Path: C:\Users\kurt\AppData\Local\PokerStars
2010/06/20 17:37:52.832: [- Main -][PokerStarsOptions] Special Path: C:\Users\kurt\AppData\Local\PokerStars
2010/06/20 17:37:53.308: [- Main -][Players] Buddies: 100:true:"fabjenmar";
2010/06/20 17:37:53.309: [- Main -][Players] 1 buddies found
2010/06/20 17:38:04.220: [- Main -][System] Getting String: PSMG=2010/05/10 14:07
2010/06/20 17:38:04.728: [- Main -][WindowStatsTab] Refreshing active player: false
2010/06/20 17:38:04.974: [- Main -][WindowStatsTab] Refreshing active player: false
2010/06/20 17:38:06.508: [- Main -][WindowMain] Database: Pokerstars_2010 Size: 188 MB
2010/06/20 17:38:06.537: [- Main -][WindowMain] Database: Pokerstars_2010 Cache Status: Holdem: 100% Holdem Tourney: 100%
2010/06/20 17:38:06.664: [00000B94][ThreadPool] New thread created
2010/06/20 17:38:06.690: [00000B94][Query::QueryThread] Thread [0x00000B94]: Begin
2010/06/20 17:38:06.692: [00000B94][Query] Connecting to database: Pokerstars_2010
2010/06/20 17:38:06.694: [00000B94][Query] Executing SQL (Thread): SELECT player.id_player, player.id_site, player.player_name, player.val_icon FROM player WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2010/06/20 17:38:06.777: [00000B94][Query] Query execution time: 82.54568667 ms :
2010/06/20 17:38:06.880: [00000B94][QueryReportCtrl::Populate] Thread [0x00000B94]: Begin
2010/06/20 17:38:07.427: [00000B94][QueryReportCtrl] Query 1: Populate: 546.5237 ms, 3119 rows, 6 cols, 0.0292 ms/col (time log: Query 1: t0: 0.0953 ms, t1: 10.1938 ms, t2: 536.1089 ms, t3: 0.0028 ms, t4: 0.0617 ms, t5: 0.0089 ms, t6: 0.0036 ms)
2010/06/20 17:38:35.505: [- Main -][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries//.xml
2010/06/20 17:38:40.726: [00000B94][Query::QueryThread] Thread [0x00000B94]: Begin
2010/06/20 17:38:40.727: [00000B94][Query] Connecting to database: Pokerstars_2010
2010/06/20 17:38:40.730: [00000B94][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 17:38:46.760: [00000B94][Query] Query execution time: 6029.77333711 ms :
2010/06/20 17:38:46.813: [00000B94][QueryReportCtrl::Populate] Thread [0x00000B94]: Begin
2010/06/20 17:39:02.508: [00000B94][QueryReportCtrl] Query 2: Populate: 15695.9614 ms, 25470 rows, 13 cols, 0.0474 ms/col (time log: Query 2: t0: 0.1782 ms, t1: 88.3143 ms, t2: 15274.0544 ms, t3: 0.0028 ms, t4: 0.2877 ms, t5: 322.8030 ms, t6: 2.2710 ms)
2010/06/20 17:39:14.373: [00000B94][Query::QueryThread] Thread [0x00000B94]: Begin
2010/06/20 17:39:14.374: [00000B94][Query] Connecting to database: Pokerstars_2010
2010/06/20 17:39:14.375: [00000B94][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 17:39:20.236: [00000B94][Query] Query execution time: 5858.91111859 ms :
2010/06/20 17:39:20.262: [00000B94][QueryReportCtrl::Populate] Thread [0x00000B94]: Begin
2010/06/20 17:39:34.901: [00000B94][QueryReportCtrl] Query 3: Populate: 14639.2877 ms, 25470 rows, 13 cols, 0.0442 ms/col (time log: Query 3: t0: 0.0349 ms, t1: 88.2076 ms, t2: 14160.6464 ms, t3: 0.0031 ms, t4: 0.3383 ms, t5: 322.9000 ms, t6: 2.0017 ms)
2010/06/20 17:39:38.426: [00000B94][Query::QueryThread] Thread [0x00000B94]: Begin
2010/06/20 17:39:38.428: [00000B94][Query] Connecting to database: Pokerstars_2010
2010/06/20 17:39:38.437: [00000B94][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (holdem_hand_player_statistics.position) as "position", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))) as "cnt_p_4bet", (sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))) as "cnt_p_4bet_opp", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )) as "cnt_p_raise_limpers", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) as "cnt_p_fold" FROM holdem_hand_player_statistics , player WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), (holdem_hand_player_statistics.id_holecard), (holdem_hand_player_statistics.position)
2010/06/20 17:39:44.199: [00000B94][Query] Query execution time: 5761.33279509 ms :
2010/06/20 17:39:44.303: [00000B94][QueryReportCtrl::Populate] Thread [0x00000B94]: Begin
2010/06/20 17:39:58.777: [00000B94][QueryReportCtrl] Query 4: Populate: 14471.3769 ms, 25470 rows, 13 cols, 0.0437 ms/col (time log: Query 4: t0: 3.2529 ms, t1: 85.6933 ms, t2: 14059.4106 ms, t3: 0.0031 ms, t4: 0.3336 ms, t5: 320.5564 ms, t6: 2.0042 ms)
2010/06/20 17:40:08.295: [- Main -][App] Shutting down subsystems...
2010/06/20 17:40:08.296: [- Main -][HudIpcInterface] Closing connection...
2010/06/20 17:40:08.340: [- Main -][System] Application exiting
2010/06/20 17:40:08.389: [- Main -][PostgresConnection] [0x05b50b60] Disconnecting from database: Pokerstars_2010
2010/06/20 17:40:08.390: [- Main -][PostgresConnection] [0x05b4d1f0] Disconnecting from database: Pokerstars_2010
2010/06/20 17:40:08.392: [- Main -][PostgresConnection] [0x05b4e0d0] Disconnecting from database: Pokerstars_2010
2010/06/20 17:40:08.393: [- Main -][PostgresConnection] [0x05b432c0] Disconnecting from database: Pokerstars_2010