diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-09-02 01:18:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-09-02 01:18:46 +0000 |
| commit | c58eb2dd7bbcd69da3093918780a00038319e75b (patch) | |
| tree | c53a48bf861b6e27031f5136b8c57b7b1053a609 | |
| parent | bf831f6e9fe18b1dd04cb5c5161afef1958b815d (diff) | |
| download | postgresql-c58eb2dd7bbcd69da3093918780a00038319e75b.tar.gz postgresql-c58eb2dd7bbcd69da3093918780a00038319e75b.zip | |
Add:
> * Consider using hash buckets to do DISTINCT, rather than sorting
>
> This would be beneficial when there are few distinct values.
| -rw-r--r-- | doc/TODO | 5 |
1 files changed, 4 insertions, 1 deletions
@@ -5,7 +5,7 @@ TODO list for PostgreSQL Bracketed items "[]" have more detail. Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Mon Aug 30 12:08:12 EDT 2004 +Last updated: Wed Sep 1 21:18:44 EDT 2004 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -802,6 +802,9 @@ Optimizer / Executor CHECK constraints contain information about the distribution of values within the table. This is also useful for implementing subtables where a tables content is distributed across several subtables. +* Consider using hash buckets to do DISTINCT, rather than sorting + + This would be beneficial when there are few distinct values. Miscellaneous |