2505 Commits (REL_13_STABLE)

Author	SHA1	Message	Date
Bruce Momjian	955ddc3e7d	< * Consider adding buffers the BGW finds reusable to the free list ... > * Consider adding buffers the background writer finds reusable to the > free list > > * Consider wither increasing BM_MAX_USAGE_COUNT improves performance > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg01007.php	18 years ago
Bruce Momjian	639c6cb712	Add URL for: ... * Reduce storage space for small NUMERICs > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00715.php	18 years ago
Bruce Momjian	ba8a9a9282	Add: ... > o Consider normalizing fractions in postgresql.conf, perhaps > using '%' > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00550.php	18 years ago
Bruce Momjian	beaef327eb	Add: ... > * Consider sorting writes during checkpoint > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00541.php	18 years ago
Bruce Momjian	a0e4f5f30a	Add: ... > > * Prefix command-line utilities like createuser with 'pg_' > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php	18 years ago
Bruce Momjian	efdb082878	Add: ... > > * Change memory allocation for multi-byte functions so memory is > allocated inside conversion functions > > Currently we preallocate memory based on worst-case usage.	18 years ago
Bruce Momjian	177eae145f	Add another URL for: ... * Consider increasing the number of default statistics target, and reduce statistics target overhead Also consider having a larger statistics target for indexed columns and expression indexes < > http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php	18 years ago
Bruce Momjian	73df8b174e	Add URL for: ... * Consider increasing the number of default statistics target, and reduce statistics target overhead Also consider having a larger statistics target for indexed columns and expression indexes > http://archives.postgresql.org/pgsql-general/2007-05/msg01228.php >	18 years ago
Bruce Momjian	d14ca04e58	Add: ... > > * Consider increasing the number of default statistics target, and > reduce statistics target overhead > > Also consider having a larger statistics target for indexed columns > and expression indexes	18 years ago
Bruce Momjian	3879b62173	Add: ... > > * Consider using a hash for joining to a large IN (VALUES ...) list > > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00450.php	18 years ago
Bruce Momjian	a2c4705702	Add for VACUUM: ... > > * Consider a more compact data representation for dead tuples > > http://archives.postgresql.org/pgsql-patches/2007-05/msg00143.php	18 years ago
Bruce Momjian	8129a814d0	Add URL for: ... * Fix problem when multiple subtransactions of the same outer transaction hold different types of locks, and one subtransaction aborts > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00773.php	18 years ago
Bruce Momjian	c3f6ca1e27	Add: ... > > * Add temporal versions of generate_series() > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg01180.php	18 years ago
Bruce Momjian	adc0ee5ea1	Add for pl/pgsql: ... o Review handling of MOVE and FETCH http://archives.postgresql.org/pgsql-patches/2007-04/msg00527.php	18 years ago
Bruce Momjian	8e4b2e354f	Add: ... > o Prevent pg_dump/pg_restore from being affected by > statement_timeout > > Using psql to restore a pg_dump dump is also affected.	18 years ago
Bruce Momjian	b633f2b98a	Add: ... > * Allow statistics last vacuum/analyze execution times to be displayed > without requiring stats_row_level to be enabled	18 years ago
Bruce Momjian	032f9d9a2e	Remove item, per Alvaro: ... < < o Set up autovacuum to ignore statement_timeout set in < postgresql.conf < < http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php	18 years ago
Bruce Momjian	bc0fc3ec5f	Add: ... > > * Consider adding buffers the BGW finds reusable to the free list > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php > > * Automatically tune bgwriter_delay based on activity rather then using a > fixed interval > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php	18 years ago
Bruce Momjian	eb34ffc15b	Add: ... > > o Set up autovacuum to ignore statement_timeout set in > postgresql.conf > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php	18 years ago
Bruce Momjian	bc963fe849	Add URL for: ... * Optimize referential integrity checks > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00744.php	18 years ago
Bruce Momjian	af7545edb7	Add URL for: ... * Allow administrators to safely terminate individual sessions either via an SQL function or SIGTERM > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00218.php	18 years ago
Bruce Momjian	b6912af22b	Add: ... > > * Consider increasing the minimum allowed number of shared buffers > > http://archives.postgresql.org/pgsql-bugs/2008-02/msg00157.php >	18 years ago
Bruce Momjian	cc05d051a6	Add: ... > > * Consider a function-based API for '@@' full text searches > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00511.php >	18 years ago
Bruce Momjian	1cc52905f0	Add: ... > > * Add a function like pg_get_indexdef() that report more detailed index > information > > http://archives.postgresql.org/pgsql-bugs/2007-12/msg00166.php >	18 years ago
Bruce Momjian	f76eee0bf1	Add: ... > > > o Prevent autovacuum from running if an old transaction is still > running from the last vacuum > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00899.php >	18 years ago
Bruce Momjian	0323f706b0	Added to TODO: ... > > * Allow text search dictionary to filter out only stop words > > http://archives.postgresql.org/pgsql-patches/2007-11/msg00081.php	18 years ago
Bruce Momjian	090012131c	Add to TODO: ... > > * Consider allowing higher priority queries to have referenced buffer > cache pages stay in memory longer > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00562.php	18 years ago
Bruce Momjian	3310b3c144	Add: ... > > * Improve referential integrity checks > > http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php	18 years ago
Bruce Momjian	4864986e94	Add item: ... > o Store per-table autovacuum settings in pg_class.reloptions. > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg01440.php > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00724.php	18 years ago
Bruce Momjian	3c361cbe57	Add URL for: ... * Allow multiple identical NOTIFY events to always be communicated to the client, rather than sent as a single notification to the listener http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php	18 years ago
Bruce Momjian	9d96b581d0	Add: ... > o Add SQLSTATE severity to PGconn return status > > http://archives.postgresql.org/pgsql-interfaces/2007-11/msg00015.php	18 years ago
Bruce Momjian	b2facfd918	Add: ... > o Have \l+ show database size, if permissions allow > > Ideally it will not generate an error for invalid permissions >	18 years ago
Bruce Momjian	cbd08f6370	Add: ... > > * Add comments on system tables/columns using the information in > catalogs.sgml > > Ideally the information would be pulled from the SGML file > automatically. >	18 years ago
Bruce Momjian	5490ccc033	Update wording: ... < o Require all check constraints to be inherited > o Require all CHECK constraints to be inherited	18 years ago
Bruce Momjian	86e39da9c6	Add: ... > > o Require all check constraints to be inherited > > http://archives.postgresql.org/pgsql-bugs/2007-04/msg00026.php	18 years ago
Bruce Momjian	868d7e2643	Add: ... > o Have \d show foreign keys that reference a table's primary key > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00424.php > > o Have \d show child tables that inherit from the specified parent	18 years ago
Bruce Momjian	60fb7187d0	Add URL for: ... * Consider compressing indexes by storing key values duplicated in several rows as a single index entry > http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php	18 years ago
Bruce Momjian	cfc4d6ef11	Add URL for: ... * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT > http://archives.postgresql.org/pgsql-patches/2007-03/msg00139.php	18 years ago
Bruce Momjian	7afc827cf6	Add URLs for: ... * Consider compressing indexes by storing key values duplicated in several rows as a single index entry > > http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php > http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php >	18 years ago
Bruce Momjian	512775e2c6	Add URL for: ... * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT > http://archives.postgresql.org/pgsql-hackers/2007-01/msg01375.php	18 years ago
Bruce Momjian	38ade59f95	Add: ... > > * Allow client certificate names to be checked against the client > hostname > > This is already implemented in > libpq/fe-secure.c::verify_peer_name_matches_certificate() but the code > is commented out.	18 years ago
Bruce Momjian	4f887c6bf0	Add: ... > > * Reduce memory usage of aggregates in set returning functions > > http://archives.postgresql.org/pgsql-performance/2008-01/msg00031.php >	18 years ago
Bruce Momjian	9772eb339d	Add: ... > > o Prevent escape string warnings when object names have > backslashes > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00227.php >	18 years ago
Bruce Momjian	0083856e01	Add: ... > * Prevent malicious functions from being executed with the permissions > of unsuspecting users > > Index functions are safe, so VACUUM and ANALYZE are safe too. > Triggers, CHECK and DEFAULT expressions, and rules are still vulnerable. > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00268.php	18 years ago
Bruce Momjian	a4591abf37	Wording fix: ... < o Have CONSTRAINT cname NOT NULL preserve the contraint name > o Have CONSTRAINT cname NOT NULL record the contraint name	18 years ago
Bruce Momjian	ecc5db57d5	Add: ... > > o Have CONSTRAINT cname NOT NULL preserve the contraint name > > Right now pg_attribute.attnotnull records the NOT NULL status > of the column, but does not record the contraint name >	18 years ago
Bruce Momjian	fca7bcbb64	Break out referential integrity and server-side languages into separate ... TODO categories.	18 years ago
Bruce Momjian	4309a7dd99	Add URL for: ... * Add support for SQL-standard GENERATED/IDENTITY columns > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00604.php	18 years ago
Bruce Momjian	af79f03bdd	Add URL for: ... * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00642.php >	18 years ago
Bruce Momjian	fd598416fc	Add: ... > > o Allow COPY FROM to create index entries in bulk > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00811.php >	18 years ago