Todo Items for pg_autovacuum client

--------------------------------------------------------------------------

_Add Startup Message (with datetime stamp) to Logfile when starting and logging

_create a FSM export function and see if I can use it for pg_autovacuum

_look into possible benifits of pgstattuple contrib work

print_table_info(tbl_info*tbl)

{

sprintf(logbuffer," table name:%s.%s",tbl->dbi->dbname,tbl->table_name);

sprintf(logbuffer," table name: %s.%s",tbl->dbi->dbname,tbl->table_name);

log_entry(logbuffer);

sprintf(logbuffer," relid: %u; relisshared: %i",tbl->relid,tbl->relisshared);

log_entry(logbuffer);

sprintf(logbuffer," reltuples: %f; relpages: %u",tbl->reltuples,tbl->relpages);

log_entry(logbuffer);

sprintf(logbuffer," curr_analyze_count:%li;cur_delete_count: %li",

sprintf(logbuffer," curr_analyze_count: %li;curr_vacuum_count: %li",

tbl->curr_analyze_count,tbl->curr_vacuum_count);

log_entry(logbuffer);

sprintf(logbuffer,"ins_at_last_analyze: %li;del_at_last_vacuum: %li",

sprintf(logbuffer,"last_analyze_count: %li;last_vacuum_count: %li",

tbl->CountAtLastAnalyze,tbl->CountAtLastVacuum);

log_entry(logbuffer);

sprintf(logbuffer,"insert_threshold:%li;delete_threshold %li",

sprintf(logbuffer,"analyze_threshold:%li;vacuum_threshold: %li",

tbl->analyze_threshold,tbl->vacuum_threshold);

log_entry(logbuffer);

fflush(LOGOUTPUT);

print_db_info(db_info*dbi,intprint_tbl_list)

{

sprintf(logbuffer,"dbname: %s Username %s Passwd %s",dbi->dbname,

dbi->username,dbi->password);

sprintf(logbuffer,"dbname: %s", (dbi->dbname) ?dbi->dbname :"(null)");

log_entry(logbuffer);

dbi->analyze_threshold,dbi->vacuum_threshold);

sprintf(logbuffer," oid: %u",dbi->oid);

log_entry(logbuffer);

sprintf(logbuffer," username: %s", (dbi->username) ?dbi->username :"(null)");

log_entry(logbuffer);

sprintf(logbuffer," password: %s", (dbi->password) ?dbi->password :"(null)");

log_entry(logbuffer);

if (dbi->conn!=NULL)

log_entry(" conn is valid,we areconnected");

log_entry("conn is valid,(connected)");

log_entry(" conn is null,we arenot connected.");

log_entry("conn is null,(not connected)");

sprintf(logbuffer," default_analyze_threshold: %li",dbi->analyze_threshold);

log_entry(logbuffer);

sprintf(logbuffer," default_vacuum_threshold: %li",dbi->vacuum_threshold);

log_entry(logbuffer);

fflush(LOGOUTPUT);

if (print_tbl_list>0)

print_table_list(dbi->table_list);

log_entry(logbuffer);

sprintf(logbuffer," args->port=%s", (args->port) ?args->port :"(null)");

log_entry(logbuffer);

sprintf(logbuffer," args->user=%s", (args->user) ?args->user :"(null)");

sprintf(logbuffer," args->username=%s", (args->user) ?args->user :"(null)");

log_entry(logbuffer);

sprintf(logbuffer," args->password=%s", (args->password) ?args->password :"(null)");

log_entry(logbuffer);

db_list=init_db_list();

if (db_list==NULL)

return1;

if (check_stats_enabled(((db_info*)DLE_VAL(DLGetHead(db_list))))!=0)

{

log_entry("Error: GUC variable stats_row_level must be enabled.");