cluster problem

[petike2222]

Hi! I always get this error when I want to cluster my database:
2010/01/09 04:41:46.067: [00000B08][PostgresConnection (Error)] Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
2010/01/09 04:41:46.068: [00000B08][PostgresConnection] Cluster complete.
I have 12Gb memory, what could be the problem?

[petike2222]

here is my complete log file:
2010/01/09 12:08:17.024: [- Main -][System] PokerTracker v3.00 beta 30.1
2010/01/09 12:08:17.024: [- Main -][SystemInfo] OS: Windows NT 6.1 (build 7600)
2010/01/09 12:08:17.024: [- Main -][SystemInfo] Windows Version: 6.1 build 7600 (platform 2)
2010/01/09 12:08:17.024: [- Main -][SystemInfo] Current Code Page: 1250
2010/01/09 12:08:17.024: [- Main -][SystemInfo] Total Physical Processors or Cores: 8
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 1: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 2: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 3: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 4: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 5: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 6: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 7: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 8: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] C:\ Disk Space: 122,096 mb total; 24,298 mb used; 97,797 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] D:\ Disk Space: 1,430,796 mb total; 681,568 mb used; 749,228 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] E:\ Disk Space: 4,673,445 mb total; 4,362,158 mb used; 311,287 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] F:\ Disk Space: 1,049,597 mb total; 268,770 mb used; 780,827 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Physical Memory: 4,096 mb (4,096 mb available) Virtual Memory: 2,048 mb (1,935 mb available) Page File: 4,096 mb (4,096 mb available)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[0]: ATI Radeon HD 4800 Series (\\.\DISPLAY1)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[1]: ATI Radeon HD 4800 Series (\\.\DISPLAY2)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[2]: ATI Radeon HD 4800 Series (\\.\DISPLAY3)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[3]: ATI Radeon HD 4800 Series (\\.\DISPLAY4)
2010/01/09 12:08:17.059: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=4,0\nMainSize=1142,1052\nMainMaximized=N\n\n\n[General]\nLogging=Y\nRegistrationCode=*** REG CODE REMOVED ***\nMinimizeToTray=Y\nBestHudPerformance=N\nInvalidText=#C0C0C0:NA\nUseCardImages=Y\nColorPositiveText=009900\nColorPositiveRow=EBFFEB\nColorNegativeText=AA0000\nColorNegativeRow=FFEBEB\n\n\n[Import]\nBeepOnCompletion=N\nClusterOnCompletion=N\nVacuumOnCompletion=N\nAnalyzeOnCompletion=N\nUpCacheOnCompletion=N\nMoveProcessedFilesDirectory=C:\Program Files (x86)\PokerTracker 3\Processed\nHidden.700=Y\nHidden.800=Y\nHidden.1000=Y\nHidden.500=Y\nHidden.300=Y\nHidden.400=Y\nHidden.1100=Y\nHidden.900=Y\nHidden.200=Y\nHidden.100=Y\nPlayedHandsDatabase=bwin import\nObservedHandsDatabase=bwin import\nImportObservedHands=N\nAutoTreatAs=Y\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nPriority=2\nMoveProcessedFiles=Y\nHidden.1200=Y\nHidden.1300=Y\nForceSetupWizard=N\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=handhq\nDB1.Default=Y\nDB1.Type=postgres\nDB1.Postgres.Database=pt3_newdb\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=bwinimport\nDB2.Type=postgres\nDB2.Postgres.Database=bwinimport\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=dbpass\n\n\n[ReportInfo]\n\n\n[HandReplayer]\nShowKnownCards=N\nAutoPlayHands=N\nShowHeroCards=Y\nShowHud=N\n\n[Messages]\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:ad6300733bb6909ea7d83b5733db3707=Y\nOptOut:b71d4740984682c07fbd139aa8cdcd3d=Y\nOptOut:aad7cd88ddec40ed2d4224a0db99936b=Y\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:f797b1cf4942ae8efd07f03a31b21636=Y\nOptOut:6d2da8f6c67067ecf0b2c21163a52862=Y\nOptOut:29398a871f8fe720b2de9674dcfd1a8d=Y\nOptOut:1b9775a152c0353de5fd74d94ea1f85c=Y\nOptOut:1e7272f2d3bafb73474900e3f7ffff06=Y\nOptOut:8c65f8d2c26c7f927b774865217277a3=Y\nOptOut:5da3f2678b14dcf5969d16bb05c79aa2=Y\nOptOut:fd55256395b90147908c33cc01783305=Y\nOptOut:e00c5c279663e243636e9c43fe17ffb8=Y\nOptOut:f826b4ff568c257d7b48e4c82c33f210=Y\nOptOut:ca181ba850dd86852eda807cab29b1d4=Y\n[Tabs]\nLast:WindowMain=2\nLast:WindowImport=1\nLast:WindowStats:Holdem=0\nLast:WindowStatsTab:holdem-cash=0\nLast:WindowStatsTab:holdem-tourney=0\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=0\nLast:WindowStatsTab:omaha-tourney=0\n[TableTracker]\nHideTablesNoStats=N\nLaunch.OnGame=bwin,C:\Program Files (x86)\bwinPoker\StartbwinPoker.exe;\nMinHands=100\nCurrentLimitOnly=N\nMinPlayers=1\nMaxPlayers=4\nShow10Max=N\nShow6Max=Y\nShow2Max=N\nBeepOnSearchComplete=Y\nScoring=0\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=IFRUOiBTY29yZQkxCTAuMDAJMC4wMA==\t\nFilters.Count=2\nLimits=$2 NL;\nLaunch.Full Tilt=Full Tilt,C:\Program Files (x86)\Full Tilt Poker\FullTiltPoker.exe;\nSites=OnGame;\n[Directories]\nManualImportFile=D:\____POKER\statisztikák\bwin\vasarolt\nl200 5000k 090726ig\petike2222_ONG_NLH200_3-6plrs_x5000k_1a77a\*\nHudImportExportDirectory=C:\Users\manfer\Desktop\\nManualImportDirectory=D:\____POKER\statisztikák\bwin\vasarolt\nl400 2010-01-06ig\nDatabaseExportDirectory=D:\____POKER\statisztikák\bwin\most\nBackupDirectory=D:\____POKER\n[Hud]\nPerformanceOption=0\nMuckedCards.Display=N\nMuckedCards.Length=3\nMuckedCards.Translucency=53\nNotes.Translucency=49\nMinHands=1\nCurrentLimit=N\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nPlayerRanges=1,2|3,5|\nRefreshRates=1,30,1|30,100,5|101,1000,10|1001,100000000,30|\nDefaultProfile.51ead1bea03db760525d57dae204191f=Tournament - tour\nDefaultProfile.b17e98b7cedb7d079f657e88a4d3fb3d=Cash - cash uj\nDatabases=handhq\nbwinimport\n[Site.OnGame]\nHandHistoryDirectories=C:\Users\ManFer\AppData\Local\P5\bwin\handhistory;\n
2010/01/09 12:08:17.133: [- Main -][System] Getting String: 1059-C98F-D5EA-D02E-3D54-3919-21B8-0325
2010/01/09 12:08:17.135: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2010/01/09 12:08:17.135: [- Main -][wxThreadedRead] Starting read thread ...
2010/01/09 12:08:17.135: [00001640][ConnectorReadThread] Thread [0x00001640]: Begin
2010/01/09 12:08:17.135: [00001640][ConnectorReadThread::Entry] Beginning thread.
2010/01/09 12:08:17.136: [- Main -][wxThreadedRead] Waiting for completion ...
2010/01/09 12:08:17.136: [00001640][ConnectorReadThread] Creating socket...
2010/01/09 12:08:17.136: [00001640][ConnectorReadThread] DNS lookup...
2010/01/09 12:08:17.143: [00001640][ConnectorReadThread] Socket connect...
2010/01/09 12:08:17.749: [00001640][ConnectorReadThread] Sending request...
2010/01/09 12:08:18.069: [00001640][ConnectorReadThread] Reading response...
2010/01/09 12:08:18.070: [00001640][ConnectorReadThread] Read complete.
2010/01/09 12:08:18.070: [00001640][ConnectorReadThread] Returning.
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Checking for Completion ...
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Waiting on the thread ...
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Getting data ...
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Calling return ...
2010/01/09 12:08:18.140: [- Main -][Registration] License written to C:\Program Files (x86)\PokerTracker 3/Data/Config/PokerTracker.lic
2010/01/09 12:08:18.143: [- Main -][System] Registered: true
2010/01/09 12:08:18.143: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/content/He ... _v1.01.cfg
2010/01/09 12:08:18.144: [- Main -][wxThreadedRead] Starting read thread ...
2010/01/09 12:08:18.144: [000017F8][ConnectorReadThread] Thread [0x000017F8]: Begin
2010/01/09 12:08:18.144: [000017F8][ConnectorReadThread::Entry] Beginning thread.
2010/01/09 12:08:18.144: [000017F8][ConnectorReadThread] Creating socket...
2010/01/09 12:08:18.145: [- Main -][wxThreadedRead] Waiting for completion ...
2010/01/09 12:08:18.145: [000017F8][ConnectorReadThread] DNS lookup...
2010/01/09 12:08:18.146: [000017F8][ConnectorReadThread] Socket connect...
2010/01/09 12:08:18.552: [000017F8][ConnectorReadThread] Sending request...
2010/01/09 12:08:18.853: [000017F8][ConnectorReadThread] Reading response...
2010/01/09 12:08:19.222: [000017F8][ConnectorReadThread] Read complete.
2010/01/09 12:08:19.222: [000017F8][ConnectorReadThread] Returning.
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Checking for Completion ...
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Waiting on the thread ...
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Getting data ...
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Calling return ...
2010/01/09 12:08:19.414: [- Main -][WindowSplash] Beginning load process
2010/01/09 12:08:19.416: [000017C0][WindowSplash::Worker::Entry] Beginning thread.
2010/01/09 12:08:19.416: [000017C0][WindowSplash::Worker] Thread [0x000017C0]: Begin
2010/01/09 12:08:19.416: [000017C0][QueryManager] Loading queries
2010/01/09 12:08:19.419: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Aliases.xml.pte
2010/01/09 12:08:19.422: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2010/01/09 12:08:19.445: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2010/01/09 12:08:19.455: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Notes.xml.pte
2010/01/09 12:08:19.458: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2010/01/09 12:08:19.482: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2010/01/09 12:08:19.493: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Players.xml.pte
2010/01/09 12:08:19.497: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2010/01/09 12:08:19.507: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2010/01/09 12:08:19.511: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.520: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2010/01/09 12:08:19.529: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2010/01/09 12:08:19.530: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2010/01/09 12:08:19.535: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2010/01/09 12:08:19.543: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2010/01/09 12:08:19.543: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2010/01/09 12:08:19.549: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.578: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2010/01/09 12:08:19.594: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2010/01/09 12:08:19.596: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2010/01/09 12:08:19.597: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.605: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2010/01/09 12:08:19.606: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2010/01/09 12:08:19.611: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2010/01/09 12:08:19.618: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.646: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2010/01/09 12:08:19.662: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2010/01/09 12:08:19.672: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2010/01/09 12:08:19.675: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.684: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2010/01/09 12:08:19.693: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2010/01/09 12:08:19.694: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2010/01/09 12:08:19.699: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2010/01/09 12:08:19.707: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2010/01/09 12:08:19.708: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2010/01/09 12:08:19.713: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.746: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2010/01/09 12:08:19.762: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2010/01/09 12:08:19.764: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2010/01/09 12:08:19.765: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.773: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2010/01/09 12:08:19.774: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2010/01/09 12:08:19.779: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2010/01/09 12:08:19.786: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.818: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2010/01/09 12:08:19.835: [000017C0][QueryManager] Queries loaded.
2010/01/09 12:08:19.835: [000017C0][StatManager] Loading stats and reports...
2010/01/09 12:08:20.782: [000017C0][StatManager] Stats and reports loaded.
2010/01/09 12:08:20.782: [000017C0][FilterManager] Loading filters...
2010/01/09 12:08:22.915: [000017C0][FilterManager] Filters loaded.
2010/01/09 12:08:22.915: [000017C0][LayoutManager] Loading layouts...
2010/01/09 12:08:23.167: [000017C0][StatManager] Loading stats and reports...
2010/01/09 12:08:24.113: [000017C0][StatManager] Stats and reports loaded.
2010/01/09 12:08:24.113: [000017C0][LayoutManager] Layouts loaded.
2010/01/09 12:08:24.116: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.150: [000017C0][PostgresConnection] [0x067b87d8] Successfully connected to: pt3_newdb [82176056] (PostgreSQL version 80402)
2010/01/09 12:08:24.164: [000017C0][ConnectionManager] Database Version: 300038
2010/01/09 12:08:24.167: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.200: [000017C0][PostgresConnection] [0x06806c18] Successfully connected to: pt3_newdb [82177096] (PostgreSQL version 80402)
2010/01/09 12:08:24.206: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.238: [000017C0][PostgresConnection] [0x06806e10] Successfully connected to: pt3_newdb [82176576] (PostgreSQL version 80402)
2010/01/09 12:08:24.244: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.277: [000017C0][PostgresConnection] [0x06806eb8] Successfully connected to: pt3_newdb [82177616] (PostgreSQL version 80402)
2010/01/09 12:08:24.282: [000017C0][WindowSplash::Worker::Entry] Ending thread.
2010/01/09 12:08:24.283: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2010/01/09 12:08:24.283: [- Main -][WindowSplash::checkProgress] Worker complete.
2010/01/09 12:08:24.471: [- Main -][Players] Buddies: 600:true:"----soy yo--";600:true:"---___Leon";600:true:"---alexandre";600:true:"---MIKKO---";600:true:"-- Z 91";600:true:"Zsld101";600:true:"zsmiki71";600:true:"Zsobo663";600:true:"Zsolt19";600:true:"Zsolt789";600:true:"zsoltF123";600:true:"zsoltmyy";600:true:"zsoszti";600:true:"ZSotol2";600:true:"zsozsozso";
2010/01/09 12:08:24.547: [- Main -][Players] 34239 buddies found
2010/01/09 12:08:27.264: [- Main -][System] Getting String:
2010/01/09 12:08:27.380: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:27.419: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:27.451: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:27.490: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:28.324: [- Main -][WindowMain] Database: handhq Size: 200 GB
2010/01/09 12:08:28.349: [00001508][ThreadPool] New thread created
2010/01/09 12:08:28.374: [00001508][Query::QueryThread] Thread [0x00001508]: Begin
2010/01/09 12:08:28.374: [00001508][Query] Connecting to database: handhq
2010/01/09 12:08:28.375: [00001508][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 omaha_table_session_summary.id_player FROM omaha_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2010/01/09 12:08:28.380: [00001508][Query] Query execution time: 4.90559495 ms :
2010/01/09 12:08:28.555: [00001508][QueryReportCtrl::Populate] Thread [0x00001508]: Begin
2010/01/09 12:08:28.555: [00001508][QueryReportCtrl] Query 1: Populate: 0.1870 ms, 0 rows, 6 cols, 0.0000 ms/col (time log: Query 1: t0: 0.0683 ms, t1: 0.0573 ms, t2: 0.0051 ms, t3: 0.0007 ms, t4: 0.0355 ms, t5: 0.0031 ms, t6: 0.0010 ms)
2010/01/09 12:08:38.432: [00000DE0][WindowDialogDatabaseHouseKeepProgress::Worker] Thread [0x00000DE0]: Begin
2010/01/09 12:08:38.433: [00000DE0][PostgresConnection] Beginning analyze.
2010/01/09 12:18:33.026: [00000DE0][PostgresConnection] Analyze complete.
2010/01/09 12:18:33.026: [00000DE0][PostgresConnection] Beginning cluster.
2010/01/09 12:53:11.031: [00000DE0][PostgresConnection (Error)] Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
2010/01/09 12:53:11.031: [00000DE0][PostgresConnection] Cluster complete.
2010/01/09 12:53:11.031: [00000DE0][WindowDialogDatabaseHouseKeepProgress (Error)] Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
2010/01/09 12:53:11.399: [000013D8][WindowDialogDatabaseHouseKeepProgress::Worker] Thread [0x000013D8]: Begin
2010/01/09 12:53:11.402: [000013D8][PostgresConnection] Beginning vacuum.

[kraada]

That error normally means you're running out of hard drive space - did you purge a lot of hands recently? If so, try running vacuum first (expect it to take a long time), then cluster.

[petike2222]

yes I have a big database, about 20-30 million hand. It's about 200 GB. But my hard drive is 1Tb and there is a 700 GB free space on it. I have never had problem earlier with clustering.It's usually running about 2-3 days but it's not a problem to me. The pt3 log file says I have 4 gb memory but really I have 12gb, why it's only see 4?

[kraada]

Hrm that's a good question - try running the memory diagnostic tool and see if it comes up with anything.

[WhiteRider]

Do you have 64-bit Windows?
Which drive is PostgreSQL itself installed on? (not necessarily where the database is stored?)

[petike2222]

I have win 7 64bit, the newest 8.4 postgres version on the System partition, but my database is on another raid0 partition. I run holdem manager and it says the same problem when I import hands, but the 2nd try I can Import all hands. The log say I have 2gb virtual memory and 4 gb page file, but I switched off both of them. Can I run 2 versions of postgres at the same time? Perhaps I install the 8.3 and check whats happen. The hands import only takes 30 hours:).

[petike2222]

I had run the memory test but it didn't find any problem.

[WhiteRider]

It's possible that the cluster is using the drive that postgres is installed on, rather than the drive that the database is saved on. When you get the message have a look at the amount of space you have on the c: drive (I assume that's where your system is?).

[tarix]

Did you modify any settings in your postgres.conf file?