Chips8
08-07-2011, 12:13 AM
I had about 9GB free on my SSD before I did the purge-vacuum and reindex. I just gor this error message while reindexing.
NOTICE: table "pg_class" was reindexedNOTICE: table "pg_type" was reindexedNOTICE: table "pg_statistic" was reindexedNOTICE: table "sql_features" was reindexed
NOTICE: table "sql_implementation_info" was reindexedNOTICE: table "sql_languages" was reindexed
NOTICE: table "sql_packages" was reindexed
NOTICE: table "sql_parts" was reindexedNOTICE: table "compiledplayerresults_month" was reindexedNOTICE: table "sql_sizing" was reindexed
NOTICE: table "sql_sizing_profiles" was reindexedNOTICE: table "pg_description" was reindexedNOTICE: table "pg_cast" was reindexed
NOTICE: table "pg_user_mapping" was reindexedNOTICE: table "pg_enum" was reindexedNOTICE: table "pg_namespace" was reindexedNOTICE: table "pg_attribute" was reindexedNOTICE: table "pg_proc" was reindexedNOTICE: table "pg_attrdef" was reindexedNOTICE: table "pg_constraint" was reindexedNOTICE: table "pg_inherits" was reindexedNOTICE: table "pg_index" was reindexedNOTICE: table "pg_operator" was reindexed
NOTICE: table "pg_opfamily" was reindexedNOTICE: table "pg_opclass" was reindexedNOTICE: table "pg_am" was reindexedNOTICE: table "pg_amop" was reindexedNOTICE: table "pg_amproc" was reindexedNOTICE: table "pg_language" was reindexedNOTICE: table "pg_largeobject" was reindexed
NOTICE: table "pg_aggregate" was reindexedNOTICE: table "pg_rewrite" was reindexedNOTICE: table "pg_trigger" was reindexedNOTICE: table "playervsplayer_hero" was reindexedNOTICE: table "pg_conversion" was reindexedNOTICE: table "pg_depend" was reindexedNOTICE: table "pg_ts_config" was reindexedNOTICE: table "pg_ts_config_map" was reindexedNOTICE: table "pg_ts_dict" was reindexed
NOTICE: table "pg_ts_parser" was reindexedNOTICE: table "pg_ts_template" was reindexed
NOTICE: table "pg_foreign_data_wrapper" was reindexedNOTICE: table "pg_foreign_server" was reindexedNOTICE: table "actiontypes" was reindexed
NOTICE: table "pokersites" was reindexedNOTICE: table "handhistories" was reindexedNOTICE: table "specialholecardactions" was reindexedNOTICE: table "importedfiles" was reindexedNOTICE: table "temppurge" was reindexedNOTICE: table "tourneydata" was reindexedNOTICE: table "allinsituations" was reindexedNOTICE: table "playerhandscashmisc" was reindexedNOTICE: table "playerhandstourneymisc" was reindexedNOTICE: table "playerhandsflop" was reindexedNOTICE: table "playerhandsturn" was reindexedNOTICE: table "playerhandsriver" was reindexedNOTICE: table "players" was reindexedNOTICE: table "pokerhands" was reindexedNOTICE: table "compiledplayerresults" was reindexed
NOTICE: table "compiledplayerresultspositionaction" was reindexedNOTICE: table "postflopactions" was reindexed
NOTICE: table "compiledresults" was reindexedNOTICE: table "tourneyplayerdata" was reindexedNOTICE: table "tables" was reindexedNOTICE: table "playerhandscashkeycolumns_hero" was reindexedNOTICE: table "allinsituations_hero" was reindexedNOTICE: table "playerhandscashmisc_hero" was reindexedNOTICE: table "specialholecardactions_hero" was reindexedNOTICE: table "playerhandstourneykeycolumns_hero" was reindexedNOTICE: table "manuallyenteredsession" was reindexedNOTICE: table "playerhandstourneymisc_hero" was reindexedNOTICE: table "playerhandsriver_hero" was reindexedNOTICE: table "rakeback" was reindexedNOTICE: table "playerhandsflop_hero" was reindexedNOTICE: table "playerhandsturn_hero" was reindexedNOTICE: table "aliases" was reindexedNOTICE: table "settings" was reindexed
NOTICE: table "tourneynotes" was reindexedNOTICE: table "hemplayernotes" was reindexedNOTICE: table "compiledplayerresultspositionaction_month" was reindexedNOTICE: table "postflopactions_month" was reindexedNOTICE: table "compiledresults_month" was reindexedNOTICE: table "holecards" was reindexedNOTICE: table "pokerhands_hero" was reindexedERROR: could not extend relation base/16397/47599: No space left on device
HINT: Check free disk space.
ERROR: could not extend relation base/16397/47599: No space left on device
HINT: Check free disk space.
I'm now left with about 2.5GB of free space. How can I reclaim the prior 9GB free I had? I've had system restore turned off. Is there a file I can delete?
NOTICE: table "pg_class" was reindexedNOTICE: table "pg_type" was reindexedNOTICE: table "pg_statistic" was reindexedNOTICE: table "sql_features" was reindexed
NOTICE: table "sql_implementation_info" was reindexedNOTICE: table "sql_languages" was reindexed
NOTICE: table "sql_packages" was reindexed
NOTICE: table "sql_parts" was reindexedNOTICE: table "compiledplayerresults_month" was reindexedNOTICE: table "sql_sizing" was reindexed
NOTICE: table "sql_sizing_profiles" was reindexedNOTICE: table "pg_description" was reindexedNOTICE: table "pg_cast" was reindexed
NOTICE: table "pg_user_mapping" was reindexedNOTICE: table "pg_enum" was reindexedNOTICE: table "pg_namespace" was reindexedNOTICE: table "pg_attribute" was reindexedNOTICE: table "pg_proc" was reindexedNOTICE: table "pg_attrdef" was reindexedNOTICE: table "pg_constraint" was reindexedNOTICE: table "pg_inherits" was reindexedNOTICE: table "pg_index" was reindexedNOTICE: table "pg_operator" was reindexed
NOTICE: table "pg_opfamily" was reindexedNOTICE: table "pg_opclass" was reindexedNOTICE: table "pg_am" was reindexedNOTICE: table "pg_amop" was reindexedNOTICE: table "pg_amproc" was reindexedNOTICE: table "pg_language" was reindexedNOTICE: table "pg_largeobject" was reindexed
NOTICE: table "pg_aggregate" was reindexedNOTICE: table "pg_rewrite" was reindexedNOTICE: table "pg_trigger" was reindexedNOTICE: table "playervsplayer_hero" was reindexedNOTICE: table "pg_conversion" was reindexedNOTICE: table "pg_depend" was reindexedNOTICE: table "pg_ts_config" was reindexedNOTICE: table "pg_ts_config_map" was reindexedNOTICE: table "pg_ts_dict" was reindexed
NOTICE: table "pg_ts_parser" was reindexedNOTICE: table "pg_ts_template" was reindexed
NOTICE: table "pg_foreign_data_wrapper" was reindexedNOTICE: table "pg_foreign_server" was reindexedNOTICE: table "actiontypes" was reindexed
NOTICE: table "pokersites" was reindexedNOTICE: table "handhistories" was reindexedNOTICE: table "specialholecardactions" was reindexedNOTICE: table "importedfiles" was reindexedNOTICE: table "temppurge" was reindexedNOTICE: table "tourneydata" was reindexedNOTICE: table "allinsituations" was reindexedNOTICE: table "playerhandscashmisc" was reindexedNOTICE: table "playerhandstourneymisc" was reindexedNOTICE: table "playerhandsflop" was reindexedNOTICE: table "playerhandsturn" was reindexedNOTICE: table "playerhandsriver" was reindexedNOTICE: table "players" was reindexedNOTICE: table "pokerhands" was reindexedNOTICE: table "compiledplayerresults" was reindexed
NOTICE: table "compiledplayerresultspositionaction" was reindexedNOTICE: table "postflopactions" was reindexed
NOTICE: table "compiledresults" was reindexedNOTICE: table "tourneyplayerdata" was reindexedNOTICE: table "tables" was reindexedNOTICE: table "playerhandscashkeycolumns_hero" was reindexedNOTICE: table "allinsituations_hero" was reindexedNOTICE: table "playerhandscashmisc_hero" was reindexedNOTICE: table "specialholecardactions_hero" was reindexedNOTICE: table "playerhandstourneykeycolumns_hero" was reindexedNOTICE: table "manuallyenteredsession" was reindexedNOTICE: table "playerhandstourneymisc_hero" was reindexedNOTICE: table "playerhandsriver_hero" was reindexedNOTICE: table "rakeback" was reindexedNOTICE: table "playerhandsflop_hero" was reindexedNOTICE: table "playerhandsturn_hero" was reindexedNOTICE: table "aliases" was reindexedNOTICE: table "settings" was reindexed
NOTICE: table "tourneynotes" was reindexedNOTICE: table "hemplayernotes" was reindexedNOTICE: table "compiledplayerresultspositionaction_month" was reindexedNOTICE: table "postflopactions_month" was reindexedNOTICE: table "compiledresults_month" was reindexedNOTICE: table "holecards" was reindexedNOTICE: table "pokerhands_hero" was reindexedERROR: could not extend relation base/16397/47599: No space left on device
HINT: Check free disk space.
ERROR: could not extend relation base/16397/47599: No space left on device
HINT: Check free disk space.
I'm now left with about 2.5GB of free space. How can I reclaim the prior 9GB free I had? I've had system restore turned off. Is there a file I can delete?