Oracle与PostgreSQL中PageSize对数据存储有哪些影响

本篇内容主要讲解“Oracle与PostgreSQL中PageSize对数据存储有哪些影响”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“Oracle与PostgreSQL中PageSize对数据存储有哪些影响”吧!Oracle数据库，Block Size设定为8K在一行数据大于Block Size时，Oracle使用行链接的方式实现跨块存储。PG的默认Block Size为8K，可以在编译安装时修改，不作任何调整，创建一张预期行占用空间可能 > 8K的数据表，插入测试数据：可以看到，虽然行数据>8K，但在PG中，这些数据都存储在一个block中（显然使用了压缩），00000000~00002000为一个block 8K。实际上，在PG中，PG使用称为TOAST (The Oversized-Attribute Storage Technique)的技术：If any of the columns of a table are TOAST-able, the table will have an associated TOAST table, whose OID is stored in the table’s pg_class.reltoastrelid entry. On-dis免费主机域名k TOASTed values are kept in the TOAST table, as described in more detail below.对于数据表的列，有四种存储选项：PLAIN prevents either compression or out-of-line storage; furthermore it disables use of single-byte headers for varlena types. This is the only possible strategy for columns of non-TOAST-able data types.
EXTENDED allows both compression and out-of-line storage. This is the default for most TOAST-able data types. Compression will be attempted first, then out-of-line storage if the row is still too big.
EXTERNAL allows out-of-line storage but not compression. Use of EXTERNAL will make substring operations on wide text and bytea columns faster (at the penalty of increased storage space) because these o免费主机域名perations are optimized to fetch only the required parts of the out-of-line value when it is not compressed.
MAIN allows compression but not out-of-line storage. (Actually, out-of-line storage will still be performed for such columns, but only as a last resort when there is no other way to make the row small enough to fit on a page.)默认选项为EXTENDED。
我们不妨尝试PLAIN和EXTERNAL这两种选项：
PLAINEXTERNAL到此，相信大家对“Oracle与PostgreSQL中PageSize对数据存储有哪些影响”有了更深的了解，不妨来实际操作一番吧！这里是云技术网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！

相关推荐: 如何解决Oracle调整表空间大小ORA-03297错误问题

这篇文章给大家分享的是有关如何解决免费主机域名Oracle调整表空间大小ORA-03297错误问题的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。Oracle调整表空间大小—ORA-03297: 文件包含在请求的 RESIZE 值以外…