aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add docs about OOM killer.Bruce Momjian2007-12-16
| | | | lst_hoe01@kwsoft.de
* Mention pg_ctl kill for Win32 in docs.Bruce Momjian2007-12-16
|
* Update pgpool-II mention.Bruce Momjian2007-12-16
|
* Mark 8.3 as likely now January, 2008 in release notes.Bruce Momjian2007-12-16
|
* Get dllwrap name from variable instead of hardcoded.Magnus Hagander2007-12-15
| | | | Per complaint from Richard Evans
* Fix example archive_command for standalone backups so it doesn't return ↵Andrew Dunstan2007-12-15
| | | | spurious non-zero.
* Use clearer error message for gmake postgres.pdf:Bruce Momjian2007-12-15
| | | | Makefile:171: *** Invalid target; use postgres-A4.pdf or postgres-US.pdf as targets. Stop.
* Improve documentation about Julian dates; in particular, point out theTom Lane2007-12-15
| | | | difference between Julian and Gregorian reckoning of when JD 0 was.
* Make error message more accuratePeter Eisentraut2007-12-14
|
* Add default error rules for making postgres.pdf and postgres.ps,Bruce Momjian2007-12-14
| | | | suggesting proper target names.
* Correct result type of convert_to, per Pavel Stehule.Alvaro Herrera2007-12-13
|
* Clarify log messagesPeter Eisentraut2007-12-13
|
* Change a couple of examples to say ALTER MAPPING instead of ADD MAPPING,Tom Lane2007-12-13
| | | | per Oleg.
* Mark items needing updating for beta stamping.Bruce Momjian2007-12-13
|
* Improve the method of localizing column names and other fixed strings inTom Lane2007-12-12
| | | | | | | | | | | | | | | psql's \d commands and other uses of printQuery(). Previously we would pass these strings through gettext() and then send them to the server as literals in the SQL query. But the code was not set up to handle doubling of quotes in the strings, causing failure if a translation attempted to use the wrong kind of quote marks, as indeed is now the case for (at least) the French translation of \dFp. Another hazard was that gettext() would translate to whatever encoding was implied by the client's LC_CTYPE setting, which might be different from the client_encoding setting, which would probably cause the server to reject the query as mis-encoded. The new arrangement is to send the untranslated ASCII strings to the server, and do the translations inside printQuery() after the query results come back. Per report from Guillaume Lelarge and subsequent discussion.
* Clean up unportable attempt to use #if inside a macro call, alsoTom Lane2007-12-12
| | | | faulty code in third arm of #if. Per buildfarm reports.
* Provide a more accurate, detailed log message when the archive command fails.Peter Eisentraut2007-12-12
|
* Add random I/O URL:Bruce Momjian2007-12-12
| | | | > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00027.php
* This item was fixed in a different way, so has been removed:Bruce Momjian2007-12-12
| | | | | | | | | | | < < * Allow free-behind capability for large sequential scans to avoid < kernel cache spoiling < < Posix_fadvise() can control both sequential/random file caching and < free-behind behavior, but it is unclear how the setting affects other < backends that also have the file open, and the feature is not supported < on all operating systems.
* Adjust release notes for HISTORY.html generation.Bruce Momjian2007-12-12
|
* Change 'merge sort join', a phrase we use nowhere else, to the moreTom Lane2007-12-12
| | | | usual 'merge join'.
* Make CSV column ordering a bit more logical.Alvaro Herrera2007-12-11
|
* Make documentation of -W options more accurate and uniform.Tom Lane2007-12-11
|
* Remove the long-deprecated -u option from psql, since it does nothing veryTom Lane2007-12-11
| | | | | | | | useful and confuses people who think it is the same as -U. (Eventually we might want to re-introduce it as being an alias for -U, but that should not happen until the switch has actually not been there for a few releases.) Likewise in pg_dump and pg_restore. Per gripe from Robert Treat and subsequent discussion.
* Typo pointed out by Erwin Brandstetter. Remove the whole makes it evenMagnus Hagander2007-12-11
| | | | better, per JD.
* Extend the format of CSV logs to include the additional information suppliedAlvaro Herrera2007-12-11
| | | | | | | with the logged event. CSV logs are now a first-class citizen along plain text logs in that they carry much of the same information. Per complaint from depesz on bug #3799.
* Use _USE_32BIT_TIME_T when building with MSVC. Also, enforce that it'sMagnus Hagander2007-12-11
| | | | | | used when building addons. Dave Page
* Remove the -P options of oid2name and pgbench, as they are securityTom Lane2007-12-11
| | | | | | | hazards. Instead teach these programs to prompt for a password when necessary, just like all our other programs. I did not bother to invent -W switches for them, since the return on investment seems so low.
* Make vacuumlo prompt for password when needed, thus making its -WTom Lane2007-12-11
| | | | | | switch optional, as is the case for every other one of our programs. I had already documented its -W as being optional, so this is bringing the code into line with the docs ...
* Remove Stefan Kaltenbrunner mention from full text release note item.Bruce Momjian2007-12-10
|
* Add release note introduction.Bruce Momjian2007-12-10
|
* Mention Stefan Kaltenbrunner as contributor for text search because ofBruce Momjian2007-12-10
| | | | psql work.
* Wording improvement for write-cache disabling instructions.Bruce Momjian2007-12-10
|
* Write cache doc cleanupsBruce Momjian2007-12-10
| | | | Greg Smith
* Document how to turn off disk write cache on popular operating systems.Bruce Momjian2007-12-10
|
* Make an editorial pass over the newly SGML-ified contrib documentation.Tom Lane2007-12-10
| | | | | | Fix lots of bad markup, bad English, bad explanations. Second round of commits. pgcrypto and pgstandby still to go...
* Change the "distributed checkpoint" release note item to Greg Smith's proposedAlvaro Herrera2007-12-10
| | | | wording.
* Update Brazilian FAQ.Bruce Momjian2007-12-10
| | | | Euler Taveira de Oliveira
* FAQ wording and markup fix.Bruce Momjian2007-12-10
| | | | Euler Taveira de Oliveira
* Fix attribution for Rime of the Ancient Mariner (obviously it's beenTom Lane2007-12-10
| | | | too long since freshman English :-()
* The E. J. Pratt verse used as a tsearch test case is unfortunately stillTom Lane2007-12-09
| | | | | under copyright in the US and many other places. Substitute a little something from a poet who's more safely dead. Per gripe from Bjorn Munch.
* Fix bogus prompt for password in -u case. Per gripe from Robert Treat.Tom Lane2007-12-09
|
* Fix up the PQconnectionUsedPassword mess: create a separateTom Lane2007-12-09
| | | | | | | | PQconnectionNeedsPassword function that tells the right thing for whether to prompt for a password, and improve PQconnectionUsedPassword so that it checks whether the password used by the connection was actually supplied as a connection argument, instead of coming from environment or a password file. Per bug report from Mark Cave-Ayland and subsequent discussion.
* Fix completely-bogus volatility markings on pg_trgm functions.Tom Lane2007-12-09
|
* Fix mergejoin cost estimation so that we consider the statistical ranges ofTom Lane2007-12-08
| | | | | | | | | | the two join variables at both ends: not only trailing rows that need not be scanned because there cannot be a match on the other side, but initial rows that will be scanned without possibly having a match. This allows a more realistic estimate of startup cost to be made, per recent pgsql-performance discussion. In passing, fix a couple of bugs that had crept into mergejoinscansel: it was not quite up to speed for the task of estimating descending-order scans, which is a new requirement in 8.3.
* In the release notes, mention that the "Overview" items are listed inBruce Momjian2007-12-08
| | | | the sections below in more detail.
* In release notes, mention "most" updates are improved with HOT.Bruce Momjian2007-12-07
|
* Remove completed 8.3 TODO items:Bruce Momjian2007-12-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | < o -Allow commenting of variables in postgresql.conf to restore them < to defaults < o -Add a GUC variable to control the tablespace for temporary objects < and sort files < Monitoring < ========== < < * -Allow server log information to be output as CSV format < * -Add ability to monitor the use of temporary sort files < * -Allow user-defined types to accept 'typmod' parameters < < http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php < http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00149.php < < * -Add Globally/Universally Unique Identifier (GUID/UUID) < < http://archives.postgresql.org/pgsql-patches/2006-09/msg00209.php < http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php < < * -Support a data type with specific enumerated values (ENUM) < o -Add support for arrays of complex types < o -Make 64-bit version of the MONEY data type < * -Add ISO day of week format 'ID' to to_char() where Monday = 1 < * -Add a field 'isoyear' to extract(), based on the ISO week < * -Add RESET SESSION command to reset all session state < o -Make CLUSTER preserve recently-dead tuples per MVCC requirements < o -Add more logical syntax CLUSTER table USING index; < support current syntax for backward compatibility < o -Allow UPDATE/DELETE WHERE CURRENT OF cursor < o -Add support for MOVE cursors < o -Allow PL/PythonU to return boolean rather than 1/0 < o -Allow psql \pset boolean variables to set to fixed values, rather < than toggle < o -Add -f to pg_dumpall < Dependency Checking < =================== < < * -Flush cached query plans when the dependent objects change or < when new ANALYZE statistics are available < * -Track dependencies in function bodies and recompile/invalidate < * -Invalidate prepared queries, like INSERT, when the table definition < is altered < < * -Allow use of indexes to search for NULLs < * -Allow the creation of indexes with mixed ascending/descending < specifiers < * -Reduce checkpoint performance degredation by forcing data to disk < more evenly < * -Allow sequential scans to take advantage of other concurrent < sequential scans, also called "Synchronised Scanning" < * -Consider shrinking expired tuples to just their headers < * -Allow heap reuse of UPDATEd rows if no indexed columns are changed, < and old and new versions are on the same heap page < * -Reduce XID consumption of read-only queries < o -Turn on by default < o -Allow multiple vacuums so large tables do not starve small < tables < * -Allow the pg_xlog directory location to be specified during initdb < with a symlink back to the /data location < * -Allow buffered WAL writes and fsync < * -Allow ORDER BY ... LIMIT # to select high/low value without sort or < index using a sequential scan for highest/lowest values < * -Merge xmin/xmax/cmin/cmax back into three header fields < o -Support a smaller header for short variable-length fields < * -Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h < * -Fix problem with excessive logging during SSL disconnection < < http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php < http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php < < o -Add long file support for binary pg_dump output
* Update HOT description to make index column changes clearer.Bruce Momjian2007-12-07
|
* Change documentation, change "distributed" checkpoints to "smoothed"Bruce Momjian2007-12-07
| | | | checkpoints.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 13:41:07 +0000