summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2010-02-23Revert recent COPY manual change about encoding; add mention of "server".Bruce Momjian
2010-02-23Clarify statements about tar archive format.Tom Lane
2010-02-23Revert recent change of to_char('HH12') handling for intervals; insteadBruce Momjian
improve documentation, and add C comment.
2010-02-23Make documentation more direct about the handling of COPY files based onBruce Momjian
the client encoding.
2010-02-23Document that expression indexes that call functions allow function-levelBruce Momjian
statistics.
2010-02-23Update pg_restore documentation to show new pg_restore custom listingBruce Momjian
format. Pavel Golub
2010-02-22Remove long-commented-out paragraph in documentation about functionBruce Momjian
inheritance in create table, per Andrew Dunstan.
2010-02-22Document that pg_ctl cares about the PGHOST environment variable.Bruce Momjian
2010-02-22Remove protocol documentation paragraph about environment variableBruce Momjian
passing being "covered elsewhere", per Dave Page.
2010-02-22Briefly document in two places that pg_dump and pg_dumpall cannot beBruce Momjian
used for continuous archiving.
2010-02-22Move documentation of all recovery.conf option to a new chapter.Heikki Linnakangas
They used to be scattered between the "backup and restore" and "streaming replication" chapters.
2010-02-20Adjust sample auto-explain output to reflect query text inclusion.Andrew Dunstan
2010-02-20Make 'include_realm' ordering consistent in the docs, to match recentBruce Momjian
doc change.
2010-02-20Clarify documentation about username mapping when authenticating withBruce Momjian
GSSAPI or Kerberos. Ian Turner
2010-02-20Document that many solid-state drives have volatile write-back caches.Bruce Momjian
2010-02-20Copy editing of Hot Standby docs. Some clarifications, additionSimon Riggs
of missing items and minor edits.
2010-02-19Document --version and --help options for all client applications (theyBruce Momjian
all support it). Per report from Josh Kupershmidt
2010-02-19First pass over client applications documentation proofreading.Bruce Momjian
gabrielle
2010-02-19Remove mention that binary distributions pre-compile the tutorial files.Bruce Momjian
2010-02-19Preliminary release notes for 9.0alpha4Peter Eisentraut
2010-02-19Hot Standby documentation updatesBruce Momjian
Greg Smith
2010-02-18Add missing close tag.Bruce Momjian
2010-02-18Wordsmithing of HS and SR documentation, with some wording improvementsBruce Momjian
from Erik Rijkers too.
2010-02-17Stamp HEAD as 9.0devel, and update various places that were referring to 8.5Tom Lane
(hope I got 'em all). Per discussion, this release will be 9.0 not 8.5.
2010-02-17Tweak description of payload parameter.Tom Lane
2010-02-16Replace the pg_listener-based LISTEN/NOTIFY mechanism with an in-memory queue.Tom Lane
In addition, add support for a "payload" string to be passed along with each notify event. This implementation should be significantly more efficient than the old one, and is also more compatible with Hot Standby usage. There is not yet any facility for HS slaves to receive notifications generated on the master, although such a thing is possible in future. Joachim Wieland, reviewed by Jeff Davis; also hacked on by me.
2010-02-16Move log_error_verbosity GUC setting to "What to log" section, andBruce Momjian
document the behavior of terse and verbose output options.
2010-02-16Honor to_char() "FM" specification in YYY, YY, and Y; it was alreadyBruce Momjian
honored by YYYY. Also document Oracle "toggle" FM behavior. Per report from Guy Rouillier
2010-02-16Have SELECT and CREATE TABLE AS queries return a row count. While thisBruce Momjian
is invisible in psql, other interfaces, like libpq, make this value visible. Boszormenyi Zoltan
2010-02-16Clarify documentation on the behavior of unnamed bind queries.Bruce Momjian
2010-02-16Fix synopsis of DO statement.Itagaki Takahiro
2010-02-15Add psql tab completion for DO blocks.Itagaki Takahiro
Also adjust documentation of DO. Patch from David Fetter and subsequent discussion.
2010-02-14Ooops, let's get the non-null vs null bit right ...Tom Lane
2010-02-14Document the behavior of STRICT VARIADIC functions.Tom Lane
2010-02-13Remove tabs from sgml.Bruce Momjian
2010-02-12Add plperl.on_plperl_init and plperl.on_plperlu_init settings for ↵Andrew Dunstan
language-specific startup. Rename recently added plperl.on_perl_init to plperl.on_init. Also, code cleanup for utf8 hack. Patch from Tim Bunce, reviewed by Alex Hunsaker.
2010-02-12Extend the set of frame options supported for window functions.Tom Lane
This patch allows the frame to start from CURRENT ROW (in either RANGE or ROWS mode), and it also adds support for ROWS n PRECEDING and ROWS n FOLLOWING start and end points. (RANGE value PRECEDING/FOLLOWING isn't there yet --- the grammar works, but that's all.) Hitoshi Harada, reviewed by Pavel Stehule
2010-02-12Update Hot Standby documentation to reflect the change in the LOGHeikki Linnakangas
messages printed at startup. As pointed out by Simon Riggs.
2010-02-12Clean up Streaming Replication documentation a little bit. A lot moreHeikki Linnakangas
needs to be done, but it's a step forward..
2010-02-09Move "Warm Standby Servers for High Availability" and "Hot Standby"Heikki Linnakangas
sections under "High Availability, Load Balancing, and Replication" chapter. Streaming replication chapter needs a lot more work, but this commit just moves things around.
2010-02-08Create an official API function for C functions to use to check if they areTom Lane
being called as aggregates, and to get the aggregate transition state memory context if needed. Use it instead of poking directly into AggState and WindowAggState in places that shouldn't know so much. We should have done this in 8.4, probably, but better late than never. Revised version of a patch by Hitoshi Harada.
2010-02-08Update high availability/replication documentation chart for new hotBruce Momjian
standby featureset.
2010-02-08Remove old-style VACUUM FULL (which was known for a little while asTom Lane
VACUUM FULL INPLACE), along with a boatload of subsidiary code and complexity. Per discussion, the use case for this method of vacuuming is no longer large enough to justify maintaining it; not to mention that we don't wish to invest the work that would be needed to make it play nicely with Hot Standby. Aside from the code directly related to old-style VACUUM FULL, this commit removes support for certain WAL record types that could only be generated within VACUUM FULL, redirect-pointer removal in heap_page_prune, and nontransactional generation of cache invalidation sinval messages (the last being the sticking point for Hot Standby). We still have to retain all code that copes with finding HEAP_MOVED_OFF and HEAP_MOVED_IN flag bits on existing tuples. This can't be removed as long as we want to support in-place update from pre-9.0 databases.
2010-02-07Create a "relation mapping" infrastructure to support changing the relfilenodesTom Lane
of shared or nailed system catalogs. This has two key benefits: * The new CLUSTER-based VACUUM FULL can be applied safely to all catalogs. * We no longer have to use an unsafe reindex-in-place approach for reindexing shared catalogs. CLUSTER on nailed catalogs now works too, although I left it disabled on shared catalogs because the resulting pg_index.indisclustered update would only be visible in one database. Since reindexing shared system catalogs is now fully transactional and crash-safe, the former special cases in REINDEX behavior have been removed; shared catalogs are treated the same as non-shared. This commit does not do anything about the recently-discussed problem of deadlocks between VACUUM FULL/CLUSTER on a system catalog and other concurrent queries; will address that in a separate patch. As a stopgap, parallel_schedule has been tweaked to run vacuum.sql by itself, to avoid such failures during the regression tests.
2010-02-05Mention warm and now "hot" standby servers in the high availability docs.Bruce Momjian
2010-02-05Document that archive_timeout will force new WAL files even if a singleBruce Momjian
checkpoint has happened, and recommend adjusting checkpoint_timeout to reduce the impact of this.
2010-02-05Previous commit was: Properly document that OVER and WINDOW are Postgres ↵Bruce Momjian
reserved words.
2010-02-05Previous commit was to have tab checking as part of gmake check.Bruce Momjian
2010-02-05*** empty log message ***Bruce Momjian
2010-02-05Improve PL/Perl documentation of database access functions.Bruce Momjian
Alexey Klyukin