diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-09-22 23:47:44 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-09-22 23:47:44 +0000 |
| commit | ec294fc6cbfa60f6ef259f36b05a5abc6e79b8c1 (patch) | |
| tree | 624c0ed29dd2ee9d54df71d91665d79958c4f08e | |
| parent | d7e4fd99e53db2a225d17738b64c6ec66e6f17f2 (diff) | |
| download | postgresql-ec294fc6cbfa60f6ef259f36b05a5abc6e79b8c1.tar.gz postgresql-ec294fc6cbfa60f6ef259f36b05a5abc6e79b8c1.zip | |
Move table constraint patch up into the main new features section of the
release notes.
| -rw-r--r-- | doc/src/sgml/release.sgml | 38 |
1 files changed, 22 insertions, 16 deletions
diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 61d7a9ce2a4..10980a359df 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.370 2005/09/22 23:24:58 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.371 2005/09/22 23:47:44 momjian Exp $ Typical markup: @@ -217,6 +217,27 @@ pg_[A-Za-z0-9_] <application> </listitem> </varlistentry> + <varlistentry> + <term> + Improve performance for partitioned tables (Simon) + </term> + + <listitem> + <para> + The new <varname>constraint_exclusion</varname> configuration + parameter avoids lookups on child tables where constraints indicate + that no matching rows exist in the child table. + </para> + <para> + This allows for a basic type of table partitioning. If child tables + store separate key ranges and this is enforced using appropriate + <command>CHECK</> constraints, the optimizer will skip child + table accesses when the constraint guarantees no matching rows + exist in the child table. + </para> + </listitem> + </varlistentry> + </variablelist> </sect2> @@ -512,21 +533,6 @@ pg_[A-Za-z0-9_] <application> <listitem> <para> - Add <varname>constraint_exclusion</varname> configuration - parameter to restrict child table lookups based on table - constraints (Simon) - </para> - <para> - This allows for a basic type of table partitioning. If child tables - store separate key ranges and this is enforced using appropriate - <command>CHECK</> constraints, the optimizer will skip child - table accesses when the constraint guarantees no matching rows - exist in the child table. - </para> - </listitem> - - <listitem> - <para> Use <literal>O_DIRECT</> if available when using <literal>O_SYNC</> for <varname>wal_sync_method</varname> (Itagaki Takahiro) |