summaryrefslogtreecommitdiff
path: root/doc/src/FAQ
AgeCommit message (Collapse)Author
2007-05-05Done:Bruce Momjian
> o -Allow multiple vacuums so large tables do not starve small
2007-05-05Wording update to FAQ_DEV..Bruce Momjian
2007-05-05Add note to FAQ_DEV that regression tests might need to be added.Bruce Momjian
2007-05-05In developer's FAQ, update list API, from Tom Lane.Bruce Momjian
2007-05-05Add FAQ item about how patches are reviewed.Bruce Momjian
2007-05-05Done:Bruce Momjian
> * -Allow ORDER BY ... LIMIT # to select high/low value without sort or < < Right now, if no index exists, ORDER BY ... LIMIT # requires we sort < all values to return the high/low value. Instead The idea is to do a < sequential scan to find the high/low value, thus avoiding the sort. < MIN/MAX already does this, but not for LIMIT > 1. <
2007-04-29Update to 8.4:Bruce Momjian
< * Make standard_conforming_strings the default in 8.3? > * Make standard_conforming_strings the default in 8.4?
2007-04-29Pl/pgsql MOVE done:Bruce Momjian
< o Add support for MOVE and SCROLL cursors < < PL/pgSQL cursors should support the same syntax as < backend cursors. < > o -Add support for MOVE cursors > o Add support for SCROLL cursors
2007-04-25Update Japanese FAQs.Bruce Momjian
Jun Kuwamura
2007-04-24Fix typo.Bruce Momjian
2007-04-24Update FAQ item:Bruce Momjian
<H3 id="item3.6">3.6) What is the upgrade process for PostgreSQL?</H3> to reference both versioning and specific upgrade instructions.
2007-04-22Done:Bruce Momjian
> o -Allow commenting of variables in postgresql.conf to restore them
2007-04-20Remove duplicate text, per Magnus.Bruce Momjian
2007-04-19Update FAQ for 8.2.4.Bruce Momjian
2007-04-18Item not done, per Pavel:Bruce Momjian
< o -Add MOVE < o -Add support for SCROLL cursors > o Add support for MOVE and SCROLL cursors
2007-04-17Update TODO for plpgsql cursors:Bruce Momjian
< o -Add support for WITH HOLD and SCROLL cursors > o -Add support for SCROLL cursors > o Add support for WITH HOLD cursors
2007-04-17Also done for PL/pgSQL:Bruce Momjian
< o Add support for WITH HOLD and SCROLL cursors > o -Add support for WITH HOLD and SCROLL cursors
2007-04-17Done:Bruce Momjian
< o Add MOVE > o -Add MOVE
2007-04-17Add warning about TODO item:Bruce Momjian
< Currently all schemas are owned by the super-user because they are < copied from the template1 database. > Currently all schemas are owned by the super-user because they are copied > from the template1 database. However, since all objects are inherited > from the template database, it is not clear that setting schemas to the db > owner is correct.
2007-04-17Not easy, per Alvaro:Bruce Momjian
< * %Set proper permissions on non-system schemas during db creation > * Set proper permissions on non-system schemas during db creation
2007-04-13Update TODO:Bruce Momjian
< o Consider reducing on-disk varlena length from four to two < because a heap row cannot be more than 64k in length > o Consider reducing on-disk varlena length from four bytes to > two because a heap row cannot be more than 64k in length
2007-04-13Update Win32 FAQ HTML version to match corrected text version.Bruce Momjian
2007-04-12Done:Bruce Momjian
> * -Add RESET SESSION command to reset all session state
2007-04-11Update text, per Greg Stark:Bruce Momjian
< o Allow single-byte header storage for arrays > o Allow single-byte header storage for array elements
2007-04-10Add:Bruce Momjian
> o Allow single-byte header storage for arrays
2007-04-10Add:Bruce Momjian
> o Have WITH CONSTRAINTS also create constraint indexes > http://archives.postgresql.org/pgsql-patches/2007-04/msg00149.php
2007-04-09Add URL for:Bruce Momjian
* Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00151.php
2007-04-08Done:Bruce Momjian
> o -Make CLUSTER preserve recently-dead tuples per MVCC requirements
2007-04-08Done:Bruce Momjian
> o -Add more logical syntax CLUSTER table USING index;
2007-04-07Done:Bruce Momjian
> * -Allow use of indexes to search for NULLs
2007-04-07Done:Bruce Momjian
o -Support a smaller header for short variable-length fields
2007-04-05Add URL for:Bruce Momjian
* Reduce WAL traffic so only modified values are written rather than entire rows > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01589.php >
2007-04-04Re-add FAQ item 3.7 which was accidentally removed in previous commit:Bruce Momjian
<H3 id="item3.7">3.7) What computer hardware should I use?</H3>
2007-04-03Done:Bruce Momjian
> o -Allow PL/PythonU to return boolean rather than 1/0
2007-04-03Update:Bruce Momjian
< * Add transaction_idle_timeout GUC so locks are not held for long > * Add idle_in_transaction_timeout GUC so locks are not held for long
2007-04-03Update:Bruce Momjian
< * Add idle_timeout GUC so locks are not held for log periods of time > * Add transaction_idle_timeout GUC so locks are not held for long > periods of time
2007-04-03Add:Bruce Momjian
> * Allow all data types to cast to and from TEXT > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00017.php > >
2007-04-03Add:Bruce Momjian
> > * Add idle_timeout GUC so locks are not held for log periods of time
2007-04-03Add URL for:Bruce Momjian
o Allow UPDATE tab SET ROW (col, ...) = (SELECT...) < > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00865.php
2007-04-02Add URL for:Bruce Momjian
o Allow commenting of variables in postgresql.conf to restore them to defaults > http://archives.postgresql.org/pgsql-patches/2007-03/msg00180.php
2007-04-02Add URL for:Bruce Momjian
o Allow a warm standby system to also allow read-only statements [pitr] > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
2007-04-02Add URL for:Bruce Momjian
* Improve speed with indexes For large table adjustments during VACUUM FULL, it is faster to cluster or reindex rather than update the index. Also, index updates can bloat the index. > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php
2007-04-02Add:Bruce Momjian
> o Have timestamp subtraction not call justify_hours()? > > http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php > < o Add overflow checking to timestamp and interval arithmetic > o Add overflow checking to timestamp and interval arithmetic
2007-04-02Pl/python -> Pl/PythonU:Bruce Momjian
< o Add table function support to pltcl, plpython > o Add table function support to pltcl, plpythonu < o Add PL/Python tracebacks > o Add PL/PythonU tracebacks < o Allow PL/Python to return boolean rather than 1/0 > o Allow PL/PythonU to return boolean rather than 1/0
2007-04-02Add:Bruce Momjian
> * Fix to_date()-related functions to consistently issue errors > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php >
2007-04-02Add:Bruce Momjian
> > o Allow PL/Python to return boolean rather than 1/0 > > http://archives.postgresql.org/pgsql-patches/2007-01/msg00596.php >
2007-04-02Add item:Bruce Momjian
> > * Consider reducing memory used for shared buffer reference count > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php
2007-04-02Add URL for:Bruce Momjian
o Allow RETURN to return row or record functions > o Allow RETURN to return row or record functions > http://archives.postgresql.org/pgsql-patches/2006-08/msg00397.php > http://archives.postgresql.org/pgsql-hackers/2006-09/msg00388.php
2007-04-02Done:Bruce Momjian
< * Support a data type with specific enumerated values (ENUM) < < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00979.php < > * -Support a data type with specific enumerated values (ENUM)
2007-04-02> o Add PQexecf() that allows complex parameter substitutionBruce Momjian
> > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01803.php
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-02 11:50:07 +0000