[HACKERS] Does Catalog contain the information of index insert/update/delete tuples number ??

2003-12-04 Thread phd9110
hi : pg_stat_user_tables store the  n_tup_ins,n_tup_upd,n_tup_del information, and those information is very useful. I check the pg_stat_user_indexes table, but there are no such information.   can i get such information in other way ? or system catalog does not store such information ! or t

[HACKERS] Where does catalog store CHAR length ?

2003-12-01 Thread phd9110
hi the table pg_attribute have the attribute  "attlen" , and this attribute willstore the attribute length. For example , when integer , this value will be 4.But if attribute type is Char(xx), this value will be -1. This is because itreference the bychar in pg_type table.So, where is the Cha

[HACKERS] rte in set_plan_rel_pathlist()

2003-10-23 Thread phd9110
  hi:in allpath.c ,the set_plan_rel_pathlist() function has a parameter of RangeTblEntry type.what does we use this varaible to do ?i doesn't see any code in this function using it .In optimizer module, it look like that we can get most information from Query . Is it right ?so , what time us