summaryrefslogtreecommitdiff
path: root/doc/src/sgml
AgeCommit message (Collapse)Author
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
2010-02-05Add SGML 'check-tabs' Makefile rule to check for tabs.Bruce Momjian
2010-02-05Modify recently added PQconnectdbParams() with new argument, expand_dbname.Joe Conway
If expand_dbname is non-zero and dbname contains an = sign, it is taken as a conninfo string in exactly the same way as if it had been passed to PQconnectdb. This is equivalent to the way PQsetdbLogin() works, allowing PQconnectdbParams() to be a complete alternative. Also improve the way the new function is called from psql and replace a previously missed call to PQsetdbLogin() in psql. Additionally use PQconnectdbParams() for pg_dump and friends, and the bin/scripts command line utilities such as vacuumdb, createdb, etc. Finally, update the documentation for the new parameter, as well as the nuances of precedence in cases where key words are repeated or duplicated in the conninfo string.
2010-02-04Three out of four of us like this phrasing better.Tom Lane
2010-02-03Mention "unquoted" identifiers are case-insensitive.Bruce Momjian
2010-02-03Proofreading improvements for the Administration documentation book.Bruce Momjian
2010-02-03Add a message type header to the CopyData messages sent from primaryHeikki Linnakangas
to standby in streaming replication. While we only have one message type at the moment, adding a message type header makes this easier to extend.
2010-02-02Make RADIUS authentication use pg_getaddrinfo_all() to get address ofMagnus Hagander
the server. Gets rid of a fairly ugly hack for Solaris, and also provides hostname and IPV6 support.
2010-02-01Remove tabs in sgml.Bruce Momjian
2010-02-01Minor documentation improvements for new string_agg aggregate.Robert Haas
2010-02-01Revoke augmentation of WAL records for btree delete, per discussion.Simon Riggs
2010-02-01Add string_agg aggregate functions. The one argument version concatenatesItagaki Takahiro
the input values into a string. The two argument version also does the same thing, but inserts delimiters between elements. Original patch by Pavel Stehule, reviewed by David E. Wheeler and me.
2010-01-30Add plperl.on_perl_init setting to provide for initializing the perl library ↵Andrew Dunstan
on load. Also, handle END blocks in plperl. Database access is disallowed during both these operations, although it might be allowed in END blocks in future. Patch from Tim Bunce.
2010-01-29Augment WAL records for btree delete with GetOldestXmin() to reduceSimon Riggs
false positives during Hot Standby conflict processing. Simple patch to enhance conflict processing, following previous discussions. Controlled by parameter minimize_standby_conflicts = on | off, with default off allows measurement of performance impact to see whether it should be set on all the time.
2010-01-29Allow psql variables to be interpolated with literal or identifier escaping.Robert Haas
Loosely based on a patch by Pavel Stehule.
2010-01-28Add new make targets "world", "install-world" and "installcheck-world" to ↵Andrew Dunstan
build, install and check just about everything. In addition to everything built installed and tested by all, install and installcheck targets, these build HTML Docs, build and test contrib, and test PLs and ECPG.
2010-01-28Type table featurePeter Eisentraut
This adds the CREATE TABLE name OF type command, per SQL standard.
2010-01-28Add functions to reset the statistics counter for a single table/index orMagnus Hagander
a single function.
2010-01-28Introduce two new libpq connection functions, PQconnectdbParams andJoe Conway
PQconnectStartParams. These are analogous to PQconnectdb and PQconnectStart respectively. They differ from the legacy functions in that they accept two NULL-terminated arrays, keywords and values, rather than conninfo strings. This avoids the need to build the conninfo string in cases where it might be inconvenient to do so. Includes documentation. Also modify psql to utilize PQconnectdbParams rather than PQsetdbLogin. This allows the new config parameter application_name to be set, which in turn is displayed in the pg_stat_activity view and included in CSV log entries. This will also ensure both new functions get regularly exercised. Patch by Guillaume Lelarge with review and minor adjustments by Joe Conway.
2010-01-27Fix typo.Magnus Hagander
Noted by Thom Brown.
2010-01-27Add support for RADIUS authentication.Magnus Hagander
2010-01-27Fix plperl.sgml errors from recent commit.Andrew Dunstan
2010-01-26Various small improvements and cleanups for PL/Perl.Andrew Dunstan
- Allow (ineffective) use of 'require' in plperl If the required module is not already loaded then it dies. So "use strict;" now works in plperl. - Pre-load the feature module if perl >= 5.10. So "use feature :5.10;" now works in plperl. - Stored procedure subs are now given names. The names are not visible in ordinary use, but they make tools like Devel::NYTProf and Devel::Cover much more useful. - Simplified and generalized the subroutine creation code. Now one code path for generating sub source code, not four. Can generate multiple 'use' statements with specific imports (which handles plperl.use_strict currently and can easily be extended to handle a plperl.use_feature=':5.12' in future). - Disallows use of Safe version 2.20 which is broken for PL/Perl. http://rt.perl.org/rt3/Ticket/Display.html?id=72068 - Assorted minor optimizations by pre-growing data structures. Patch from Tim Bunce, reviewed by Alex Hunsaker.
2010-01-26Remove the default_do_language parameter, instead making DO use a hardwiredTom Lane
default of "plpgsql". This is more reasonable than it was when the DO patch was written, because we have since decided that plpgsql should be installed by default. Per discussion, having a parameter for this doesn't seem useful enough to justify the risk of application breakage if the value is changed unexpectedly.
2010-01-26Remove tabs in SGML.Bruce Momjian
2010-01-26Finally applied patch by Boszormenyi Zoltan <zb@cybertec.at> to add the new ↵Michael Meskes
features his patches added to the docs.
2010-01-26Make the default pg_hba.conf and pg_ident.conf align at 8-character boundariesPeter Eisentraut
to make it easier to use with tabs.
2010-01-25Add get_bit/set_bit functions for bit strings, paralleling those for bytea,Tom Lane
and implement OVERLAY() for bit strings and bytea. In passing also convert text OVERLAY() to a true built-in, instead of relying on a SQL function. Leonardo F, reviewed by Kevin Grittner
2010-01-25Add note that PREPARE TRANSACTION is for transaction managers, notHeikki Linnakangas
regular applications. Also add a comment pointing out that tab-complition for PREPARE TRANSACTION is missing on purpose.
2010-01-24Add missing closing tag.Magnus Hagander
2010-01-23In HS, Startup process sets SIGALRM when waiting for buffer pin. IfSimon Riggs
woken by alarm we send SIGUSR1 to all backends requesting that they check to see if they are blocking Startup process. If so, they throw ERROR/FATAL as for other conflict resolutions. Deadlock stop gap removed. max_standby_delay = -1 option removed to prevent deadlock.
2010-01-22Revert mention that HTML documentation has to be built first.Bruce Momjian
Now require gmake 3.79.1 or later to build source/sgml.
2010-01-22Fix mismatched tags introduced by attribute options patch.Robert Haas
Thanks to Devrim Gunduz for the report.
2010-01-22Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism.Robert Haas
Attributes can now have options, just as relations and tablespaces do, and the reloptions code is used to parse, validate, and store them. For simplicity and because these options are not performance critical, we store them in a separate cache rather than the main relcache. Thanks to Alex Hunsaker for the review.
2010-01-22Document that the HTML documentation must be built before the PDFBruce Momjian
documentation.
2010-01-22PL/Python DO handlerPeter Eisentraut
Also cleaned up some redundancies between the primary error messages and the error context in PL/Python. Hannu Valtonen
2010-01-21Add new escaping functions PQescapeLiteral and PQescapeIdentifier.Robert Haas
PQescapeLiteral is similar to PQescapeStringConn, but it relieves the caller of the need to know how large the output buffer should be, and it provides the appropriate quoting (in addition to escaping special characers within the string). PQescapeIdentifier provides similar functionality for escaping identifiers. Per recent discussion with Tom Lane.
2010-01-20Add user-specific .pg_service.conf filePeter Eisentraut
This extends the existing pg_service.conf facility to first look for a service definition file in the user's home directory.
2010-01-20Fix doc build, which was broken by PL/perl utility functions patch.Robert Haas
2010-01-20Add utility functions to PLPerl:Andrew Dunstan
quote_literal, quote_nullable, quote_ident, encode_bytea, decode_bytea, looks_like_number, encode_array_literal, encode_array_constructor. Split SPI.xs into two - SPI.xs now contains only SPI functions. Remainder are in new Util.xs. Some more code and documentation cleanup along the way, as well as adding some CVS markers to files missing them. Original patch from Tim Bunce, with a little editing from me.
2010-01-20Reformat documentation of libpq escaping functions.Robert Haas
Modify the "Escaping Strings for Inclusion in SQL Commands" section to use a <variablelist> as the preceding and following sections do, and merge the "Escaping Binary Strings for Inclusion in SQL Commands" section into it. This changes only the formatting of these sections, not the content. It is intended to lay the groundwork for a follow-on patch to add some new escaping functions, but it makes sense to commit this first, for clarity.
2010-01-19Add pg_stat_reset_shared('bgwriter') to reset the cluster-wide sharedMagnus Hagander
statistics of the bgwriter. Greg Smith
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-03 15:27:06 +0000