- 07 Oct, 2005 2 commits
-
-
Bruce Momjian authored
< * Consider compressing indexes by storing key prefix values shared by > * Consider compressing indexes by storing key values duplicated in 735a736,737 > > This is difficult because it requires datatype-specific knowledge.
-
Bruce Momjian authored
< > * Consider compressing indexes by storing key prefix values shared by > several rows as a single index entry
-
- 03 Oct, 2005 2 commits
-
-
Bruce Momjian authored
< * -Have sequence dependency track use of DEFAULT sequences
-
Bruce Momjian authored
< * Have sequence dependency track use of DEFAULT sequences, < seqname.nextval? > * -Have sequence dependency track use of DEFAULT sequences
-
- 27 Sep, 2005 3 commits
-
-
Bruce Momjian authored
< * +Add options to pg_config to show the share_dir, sysconfdir, < pkgincludedir, and localedir
-
Bruce Momjian authored
> o Improve signal handling, > http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php
-
Bruce Momjian authored
< * Add options to pg_config to show the share_dir, sysconfdir, > * +Add options to pg_config to show the share_dir, sysconfdir,
-
- 26 Sep, 2005 2 commits
-
-
Bruce Momjian authored
< * Allow protocol-level EXECUTE that is actually a fetch to appear < in the logs as a fetch rather than another execute
-
Bruce Momjian authored
> * Allow protocol-level BIND parameter values to be logged > * Allow protocol-level EXECUTE that is actually a fetch to appear > in the logs as a fetch rather than another execute
-
- 23 Sep, 2005 5 commits
-
-
Bruce Momjian authored
> * Simplify dropping roles that have objects in several databases
-
Bruce Momjian authored
> o Allow PL/PgSQL to support WITH HOLD cursors
-
Bruce Momjian authored
> > o Display IN, INOUT, and OUT parameters in \df+ > > It probably requires psql to output newlines in the proper > column, which is already on the TODO list.
-
Bruce Momjian authored
> * Add function to report the time of the most recent server reload
-
Bruce Momjian authored
> * Add options to pg_config to show the share_dir, sysconfdir, > pkgincludedir, and localedir >
-
- 22 Sep, 2005 3 commits
-
-
Bruce Momjian authored
> * Allow CREATE INDEX to take an additional parameter for use with > special index types >
-
Bruce Momjian authored
> > Another idea would be to allow actual SELECT queries in a COPY.
-
Bruce Momjian authored
> > o Allow COPY to output from views >
-
- 20 Sep, 2005 4 commits
-
-
Bruce Momjian authored
< This would be beneficial when there are few distinct values. > This would be beneficial when there are few distinct values. This is > already used by GROUP BY. 946d946 < * Allow DISTINCT to use hashing like GROUP BY
-
Bruce Momjian authored
< * Allow WAL traffic to be steamed to another server for stand-by > * Allow WAL traffic to be streamed to another server for stand-by
-
Bruce Momjian authored
> * Allow DISTINCT to use hashing like GROUP BY
-
Bruce Momjian authored
> * Allow WAL traffic to be steamed to another server for stand-by > replication
-
- 19 Sep, 2005 2 commits
-
-
Bruce Momjian authored
< * Research use of sched_yield() for spinlock acquisition failure
-
Bruce Momjian authored
-
- 17 Sep, 2005 1 commit
-
-
Bruce Momjian authored
> 1032a1034 > * Remove BeOS and QNX-specific code
-
- 16 Sep, 2005 4 commits
-
-
Bruce Momjian authored
> o Fix SELECT INTERVAL '1' MONTH
-
Bruce Momjian authored
< > * Update Bonjour to work with newer cross-platform SDK
-
Bruce Momjian authored
< 390d388 < 453c451 < removed or have its heap and index files truncated. One > be removed or have its heap and index files truncated. One < * Use a phantom command counter for nested subtransactions to reduce < per-tuple overhead
-
Bruce Momjian authored
> o Add single-step debugging of PL/PgSQL functions
-
- 03 Sep, 2005 1 commit
-
-
Bruce Momjian authored
< cmin/cmax pair and is stored in local memory. > cmin/cmax pair and is stored in local memory. Another idea is to > store both cmin and cmax only in local memory.
-
- 02 Sep, 2005 8 commits
-
-
Bruce Momjian authored
< have its heap and index files truncated. One issue is < that no other backend should be able to add to the table < at the same time, which is something that is currently < allowed. > removed or have its heap and index files truncated. One > issue is that no other backend should be able to add to > the table at the same time, which is something that is > currently allowed.
-
Bruce Momjian authored
> o Allow COPY on a newly-created table to skip WAL logging 450a452,456 > On crash recovery, the table involved in the COPY would > have its heap and index files truncated. One issue is > that no other backend should be able to add to the table > at the same time, which is something that is currently > allowed.
-
Bruce Momjian authored
< o Allow COPY into an empty table to skip WAL logging > o Allow COPY into an new table to skip WAL logging
-
Bruce Momjian authored
> * Use UTF8 encoding for NLS messages so all server encodings can > read them properly < o %Add support for Unicode < < To fix this, the data needs to be converted to/from UTF16/UTF8 < so the Win32 wcscoll() can be used, and perhaps other functions < like towupper(). However, UTF8 already works with normal < locales but provides no ordering or character set classes.
-
Bruce Momjian authored
< could only see committed rows from another transaction. However, > could only see rows from another completed transaction. However, 981c981 < proper visibility of the row, for example, for cursors. > proper visibility of the row's cmin, for example, for cursors.
-
Bruce Momjian authored
> o Allow COPY into an empty table to skip WAL logging
-
Bruce Momjian authored
* Merge xmin/xmax/cmin/cmax back into three header fields Before subtransactions, there used to be only three fields needed to store these four values. This was possible because only the current transaction looks at the cmin/cmax values. If the current transaction created and expired the row the fields stored where xmin (same as xmax), cmin, cmax, and if the transaction was expiring a row from a another transaction, the fields stored were xmin (cmin was not needed), xmax, and cmax. Such a system worked because a transaction could only see committed rows from another transaction. However, subtransactions can see rows from outer transactions, and once the subtransaction completes, the outer transaction continues, requiring the storage of all four fields. With subtransactions, an outer transaction can create a row, a subtransaction expire it, and when the subtransaction completes, the outer transaction still has to have proper visibility of the row, for example, for cursors. One possible solution is to create a phantom cid which represents a cmin/cmax pair and is stored in local memory.
-
Bruce Momjian authored
< * Maintain a map of recently-expired rows < < This allows vacuum to target specific pages for possible free space < without requiring a sequential scan. < Update entry: > One complexity is that index entries still have to be vacuumed, and > doing this without an index scan (by using the heap values to find the > index entry) might be slow and unreliable, especially for user-defined > index functions.
-
- 30 Aug, 2005 1 commit
-
-
Bruce Momjian authored
> * Eventually enable escape_string_warning and standard_conforming_strings
-
- 28 Aug, 2005 1 commit
-
-
Bruce Momjian authored
> * Add function to return the thread safety status of libpq and ecpg
-
- 27 Aug, 2005 1 commit
-
-
Bruce Momjian authored
> * Allow user-defined types to specify a type modifier at table creation > time
-