postgres tuning -- crashes

[tarix]

Does this mean that i MUST use postgres 9.x now?

No, just make sure you don't tell postgres to use more than ~4GB of RAM because it won't be able to. Also, don't forget that postgres relies on the operating system to cache it's file efficiently so it's more important that Windows has access to large amounts of RAM.

That isn't to say you wouldn't see some performance improvement from upgrading to a 64bit postgres, but it's not required to get the most out of 8GB of RAM.

[zubs1aa]

Does this mean that i MUST use postgres 9.x now?

No, just make sure you don't tell postgres to use more than ~4GB of RAM because it won't be able to. Also, don't forget that postgres relies on the operating system to cache it's file efficiently so it's more important that Windows has access to large amounts of RAM.

That isn't to say you wouldn't see some performance improvement from upgrading to a 64bit postgres, but it's not required to get the most out of 8GB of RAM.

Ugg lol silly me for not being more specific.

I don't really care which version I use, other than I'd prefer to use the most efficient yet stable version. So what's the official/unofficial recommendation for 64 bit? (And the answer to that ought to be in one of your tutorials as a large number of users will be running 64 bit machines at this point. In fact, if the recommendation is to jump to 9x in this case, you ought to have a 64bit download/upgrade version bundle on the download PT3 software page?

[zubs1aa]

More info.

I was looking at my log file for other reasons, and noticed that even though I installed 64bit 9x, it only seems to be recognizing 4G of memory when i have 8gb.

Is this the expected behavior? see the bolded line i broke out below as it reviews the specs...

2010/12/04 12:30:41.619: [- Main -][System] PokerTracker v3.08.1
2010/12/04 12:30:41.645: [- Main -][SystemInfo] OS: Windows NT 6.1 (build 7600)
2010/12/04 12:30:41.654: [- Main -][SystemInfo] Windows Version: 6.1 build 7600 (platform 2)
2010/12/04 12:30:41.670: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2010/12/04 12:30:41.679: [- Main -][SystemInfo] Total Logical Processing Units: 8
2010/12/04 12:30:41.687: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 4 PUs: 8 (L1: 4, L2: 4, L3: 1)
2010/12/04 12:30:41.696: [- Main -][SystemInfo] Processor 1: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.704: [- Main -][SystemInfo] Processor 2: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.721: [- Main -][SystemInfo] Processor 3: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.729: [- Main -][SystemInfo] Processor 4: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.737: [- Main -][SystemInfo] Processor 5: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.746: [- Main -][SystemInfo] Processor 6: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.762: [- Main -][SystemInfo] Processor 7: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.771: [- Main -][SystemInfo] Processor 8: Speed: 1.60 GHz Name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
2010/12/04 12:30:41.779: [- Main -][SystemInfo] C:\ Disk Space: 467,964 mb total; 50,496 mb used; 417,468 mb free


2010/12/04 12:30:41.791: [- Main -][SystemInfo] Physical Memory: 4,096 mb (4,096 mb available) Virtual Memory: 2,048 mb (1,933 mb available) Page File: 4,096 mb (4,096 mb available)



2010/12/04 12:30:41.801: [- Main -][System Info] Video[0]: ATI Mobility Radeon HD 5470 (\\.\DISPLAY1)
2010/12/04 12:30:41.887: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=54,160\nMainSize=1187,735\nMainMaximized=N\n\n\n[General]\nLogging=Y\nBuildDate=2010/11/30\nRegistrationCode=*** REG CODE REMOVED ***\nBestHudPerformance=N\nInvalidText=#C0C0C0:na\nUseCardImages=Y\nColorPositiveText=009900\nColorPositiveRow=EBFFEB\nColorNegativeText=AA0000\nColorNegativeRow=FFEBEB\n\n\n[Import]\nBeepOnCompletion=Y\nClusterOnCompletion=N\nVacuumOnCompletion=N\nAnalyzeOnCompletion=N\nUpCacheOnCompletion=N\nAutoStart.1400=N\nAutoStart.1300=N\nAutoStart.700=N\nAutoStart.1200=N\nAutoStart.800=N\nAutoStart.1000=N\nAutoStart.500=N\nAutoStart.300=Y\nAutoStart.400=N\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=N\nAutoStart.900=N\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.1800=N\nForceSetupWizard=N\nHidden.1400=Y\nHidden.700=Y\nHidden.1000=Y\nHidden.400=Y\nHidden.1100=Y\nHidden.600=Y\nHidden.900=Y\nHidden.200=Y\nHidden.1800=Y\nHidden.500=Y\nIncludeSubDirectories=N\nCloseOnCompletion=N\nStartHud=Y\nPriority=2\nAutoTreatAs=Y\nEmail:Pop:Server=pop.gmail.com\nEmail:Pop:Port=995\nEmail:Pop:User=arik.poker@gmail.com\nEmail:Pop:Password=^E:awdJH1EmDnBUBgo=\nEmail:Pop:UseSSL=Y\nImportObservedHands=Y\nDetectOnCompletion=Y\nMoveProcessedFilesDirectory=G:\PT3 Processed Hands\nOverwriteTournamentSummary=Y\nMoveProcessedFiles=Y\nHidden.2200=Y\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDB1.Name=3.6.2 rebuild May 2010\nDB1.Type=postgres\nDB1.Postgres.Database=3.6.2 rebuild may 2010\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB2.Name=2009 Full Tilt Hand Import- CASH\nDB2.Type=postgres\nDB2.Postgres.Database=PT3_2010_05_13_001028- 2009 FTP\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=dbpass\nDB3.Name=3.6.2 rebuild May 2010- restored June\nDB3.Type=postgres\nDB3.Postgres.Database=3.6.2 rebuild may 2010-restored june\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB1.Default=Y\nDB4.Name=superturbo test\nDB4.Type=postgres\nDB4.Postgres.Database=PT3_2010_09_18_053540-supers\nDB4.Postgres.Server=localhost\nDB4.Postgres.Port=5432\nDB4.Postgres.User=postgres\nDB4.Postgres.Password=dbpass\nDefault.Postgres.Password=dbpass\nDB1.Postgres.Password=dbpass\n\n\n[ReportInfo]\n\n\n[HandReplayer]\nShowHud=N\nShowHeroCards=Y\nShowKnownCards=Y\n\n[Site.Betfair]\nHandHistoryDirectories=-\n[Site.Boss]\nHandHistoryDirectories=-;\n[Site.Entraction]\nHandHistoryDirectories=-\n[Site.Everest]\nHandHistoryDirectories=-\n[Site.iPoker]\nHandHistoryDirectories=-\n[Site.Merge]\nHandHistoryDirectories=C:\Program Files\Merge\PlayersOnly\history;C:\Program Files\PokerHost\history;C:\Program Files\Merge\PlayersOnly.50Beta\history;\nPreferred.10=9\nPreferred.6=6\nPreferred.9=9\n[Site.MicroGaming]\nHandHistoryDatabases=-\n[Site.OnGame]\nHandHistoryDirectories=-;\n[Site.Pacific]\nHandHistoryDirectories=-\n[Site.Party]\nHandHistoryDirectories=-\n[Site.Bodog]\nHandHistoryDirectory=G:\zubs1aa- Bodog\n[Site.Cake]\nHandHistoryDirectories=C:\Program Files\DoylesRoom\Hand Histories\;\n[Site.Cereus]\nHandHistoryDirectories=C:\Program Files\UltimateBet\HandHistory;C:\Program Files\Absolute Poker\HandHistory\ZUBS1AAA;\nPreferred.0.9=6\nPreferred.2.9=6\nPreferred.2.6=4\nPreferred.0.6=4\nPreferred.1.9=6\n[Directories]\nManualImportDirectory=G:\PT3 Alpha Installs\PokerTracker 3\Processed\nManualImportFile=C:\Documents and Settings\Arik Marks\Desktop\*\nBackupDirectory=D:\PokerTracker V3 Baks\nPostgresBin=\PostgreSQL PT3\bin\nDatabaseExportDirectory=G:\Holder\nHudImportExportDirectory=C:\Documents and Settings\Arik Marks\Desktop\\n[Tabs]\nLast:WindowMain=0\nLast:WindowImport=1\nLast:WindowStats:Holdem=0\nLast:WindowStatsTab:holdem-cash=3\nLast:WindowStatsTab:holdem-tourney=3\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=3\nLast:WindowStatsTab:omaha-tourney=3\nShow:Main:TableTracker=N\n[TableTracker]\nHideTablesNoStats=N\nLaunch.Cereus Network=UltimateBet,C:\Program Files\UltimateBet\mainclient.exe;\nLaunch.Full Tilt=Full Tilt,C:\Program Files\Full Tilt Poker\FullTiltPoker.exe;\nLaunch.PokerStars=PokerStars,C:\Program Files\PokerStars/PokerStars.exe;\nMinHands=5\nCurrentLimitOnly=N\nMinPlayers=1\nMaxPlayers=10\nShow10Max=Y\nShow6Max=Y\nShow2Max=N\nBeepOnSearchComplete=Y\nScoring=1\nFilters.1.Type=0\nFilters.1.Result=100\nFilters.1.Color=15461375\nFilters.1.Rules.1=IFRUOiBTY29yZQkzCTAJMA==\t\nFilters.2.Type=0\nFilters.2.Result=100\nFilters.2.Color=15466475\nFilters.2.Rules.1=IFRUOiBTY29yZQkxCTAJMA==\t\nFilters.Count=2\nLimits=$0.02 NL;\nGameIndex=0\n[Messages]\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:4e97665d8bb300c92b97914d8b2f12a4=Y\nOptOut:ca181ba850dd86852eda807cab29b1d4=Y\nOptOut:1b9775a152c0353de5fd74d94ea1f85c=Y\nOptOut:785c912f5c8fe02e62d9a8d44f0fed84=Y\nOptOut:218b96d1c4038f78923963117951eceb=Y\n[Hud]\nDefaultProfile.af86cf3229b4c97c961d3f6ef7dbf3d9=Tournament - Tny- Arik- Mod- Live -2\nDefaultProfile.9f3ff5d4e13e733110901fde48aa5da9=Tournament - arik-tny--mod-new exp\nDefaultProfile.9af6fa4763f95811017ea89c9eea78c6=Tournament - arik-tny--mod-new exp\nDefaultProfile.f9c911810a7b4fef29b985ac12a9a299=Tournament - arik-tny--mod-new exp\nDefaultProfile.82a223ca71416a988a2d85a6a2d39e84=Tournament - Tny- Arik- Mod- Live -2\nDefaultProfile.66844e7678df036851e26af24ad337bc=Tournament - Tournament-Arik-tny-mod-new-exp-DOG -10\nDefaultProfile.8ffbba965db5ff77e4694363ff640dc7=Tournament - Tny- Arik- Mod- Live -2\nDefaultProfile.8320f2af91c009d58391af944b73b6e1=Tournament - Tny- Arik- Mod- Live -2\nMuckedCards.Display=Y\nMuckedCards.Length=1\nMuckedCards.Translucency=80\nNotes.Translucency=20\nMinHands=1\nCurrentLimit=N\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nRefreshRates=0,100,1|400,99999,5|101,399,2|\nDefaultProfile.bf0d319489e43e75835e59afc26cdd80=Tournament - Tny- Arik- Mod- Live -2\nNotesSize=450,150\nDefaultProfile.e14cb0b165a37742a43b1a37ed5f75f9=Tournament - arik-tny--mod-new exp\nDefaultProfile.de9beb30f9153f60136ca55845dae903=Tournament - Tny- Arik- Mod- Live -2\nDefaultProfile.9acfaf47bfef181978d0cc00dd5a226f=Tournament - Tny- Arik - Mod LIVE\nDefaultProfile.1a24e1c8e5450923b1489fa13822703b=Tournament - Tny- Arik - Mod LIVE\nDefaultProfile.32e4a4c1a61439a84f9f4660d3036197=Tournament - arik-tny--mod-new exp\nDefaultProfile.740bc212f7f04fa38dec372d6a5226a9=Tournament - Tny- Arik- Mod- Live -2\nDefaultProfile.b39faecb57a186f5625114758cd47682=Tournament - Tny- Arik- Mod- Live -2\n[HandFormatting]\nDisplayHandHistory=Y\nDisplaySmallCards=Y\nHidePlayerNames=N\n[Site.PokerStars]\nMemoryGrabber=Y\nHandHistoryDirectory=C:\Program Files\PokerStars\HandHistory\n[Site.FullTilt]\nRushHud=Y\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=N\nCheckBoxSaveType=Y\nDefaultTables=0\nDefaultMinsPerRound=10\n
2010/12/04 12:30:42.013: [- Main -][System] Getting String: 1059-F257-16AB-DC8E-8B26-3919-7B8A-0FC2

[WhiteRider]

That may be the way the available memory is read - we seem to see logs showing 2GB for systems which have 4 on XP (for instance). I'll see if I can find out for you.

[zubs1aa]

That may be the way the available memory is read - we seem to see logs showing 2GB for systems which have 4 on XP (for instance). I'll see if I can find out for you.

Thanks

[tarix]

I was looking at my log file for other reasons, and noticed that even though I installed 64bit 9x, it only seems to be recognizing 4G of memory when i have 8gb.

32bit programs under 64bit Windows only have access to 4GB of memory.