relation "public.***" contains more than "max_fsm_pages" pages with useful free space
来源:互联网 发布:r创建数据集 dataframe 编辑:程序博客网 时间:2024/06/06 00:32
有时我们在操作大表的时候会发生relation “public.*” contains more than “max_fsm_pages” pages with useful free space的错误,其实这个错误和max_fsm_pages参数有关。
max_fsm_pages必须大于 16 * max_fsm_relations,且max_fsm_pages最小必须为100,看出当max_fsm_pages不足时,表中的无效元组还是删除掉了的
max_fsm_pages在greenplum中的默认值是200000,greenplum中每张数据页的大小是32K,200000*32K约为6.1G,而且这还是每个实例上的数值
在GPDB中,vacuum会提示fsm不足如果你是10节点,出错了就说明你操作的表数据已经超过6.1*10=61G.其实GPDB的max_fsm_pages的默认值比postgresql大很多,没有必要再继续提高此参数。
解决方案:找个业务不太繁忙的时间vacuum full该表就行了。
0 0
- relation "public.***" contains more than "max_fsm_pages" pages with useful free space
- Windows Developer Power Tools: Turbocharge Windows Development with More Than 140 Free and Open Sour
- how to free up more space in boot partition with Ubuntu16.04
- Useful tips to scrapy web pages with Python(Request)
- Why Free Software Is More Important Now Than Ever Before
- Likelihood ratios for tests with more than two possible results
- Windows Cannot Hibernate Computer with More Than 4 GB Memory
- more than one row with the given identifier was found
- Error:more than one library with package name
- 'block' tag with name 'content' appears more than once
- More than one file was found with OS independent path
- InfoPath error : "a dataset that contains a table name that is defined more than once"
- RVDS4.0 :armlink : ambiguous section selection . object 2440init.o contains more than one section.
- Useful Pages for Deep Learning
- More Effective C++ 31. Making functions virtual with respect to more than one object
- more than and less than
- no more than VS not more than
- Useful Free Tools I Like
- STM32启动文件
- iOS界面约束第三方框架对比
- 获取网络文本查看器--HTML源码
- 树状数组
- C语言如何获得变量的物理地址以及简单的写时拷贝测试
- relation "public.***" contains more than "max_fsm_pages" pages with useful free space
- Spring的AOP详解
- 详解HttpURLConnection
- 深入浅出RxJava(二:操作符)
- Linux内存中的Cache真的能被回收吗?
- bzoj 3626 LCA
- 隐私政策
- 建造者模式的实现
- 学习笔记之深入浅出MFC 第8章 C++重要性质----虚拟函数与多态(Polymorphism)