summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/reindex.sgml
Commit message (Collapse)AuthorAgeFilesLines
* Update reference documentation on may/can/might:Bruce Momjian2007-01-311-6/+6
| | | | | | | | | | | | | | Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unfortunately, in conversational English, their use is often mixed, as in, "You may use this variable to do X", when in fact, "can" is a better choice. Similarly, "It may crash" is better stated, "It might crash".
* Add missing reference to pg_shdescription. Greg MullaneTom Lane2007-01-051-2/+3
|
* Add text to the VACUUM, REINDEX, DROP TABLESPACE and CREATE TABLESPACENeil Conway2006-10-311-2/+5
| | | | | | | reference pages documenting that these commands cannot be used within a transaction block. Also make some minor improvements to the psql reference page. Patch from Simon Riggs, minor editorialization by myself.
* Remove emacs info from footer of SGML files.Bruce Momjian2006-09-161-18/+1
|
* Add the ability to create indexes 'concurrently', that is, withoutTom Lane2006-08-251-2/+14
| | | | | blocking concurrent writes to the table. Greg Stark, with a little help from Tom Lane.
* Documentation fixes for FILLFACTOR patch. Minor other editorialization.Tom Lane2006-07-041-9/+16
|
* Merge postmaster and postgres command into just postgres. postmasterPeter Eisentraut2006-06-181-4/+4
| | | | | symlink is kept for now for compatibility. To call single-user mode, use postgres --single.
* Forgot to add pg_pltemplate to the list of shared system catalogs thatTom Lane2005-09-121-3/+4
| | | | appears in the REINDEX ref page.
* Clean up some stray remaining references to pg_shadow, pg_user, pg_group.Tom Lane2005-08-151-4/+5
|
* Make REINDEX DATABASE do what one would expect, namely reindex all indexesTom Lane2005-06-221-18/+45
| | | | | | | in the database. The old behavior (reindex system catalogs only) is now available as REINDEX SYSTEM. I did not add the complementary REINDEX USER case since there did not seem to be consensus for this, but it would be trivial to add later. Per recent discussions.
* More < and > changes to ampersands.Bruce Momjian2005-01-221-3/+3
| | | | 8.0.X and HEAD.
* Minor documentation updates from Simon Riggs.Tom Lane2004-11-041-9/+21
|
* Update for 8.0: pg_tablespace is now also a shared catalog.Tom Lane2004-10-241-3/+4
|
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* Adjust btree index build procedure so that the btree metapage looksTom Lane2003-09-291-4/+5
| | | | | | | | | | invalid (has the wrong magic number) until the build is entirely complete. This turns out to cost no additional writes in the normal case, since we were rewriting the metapage at the end of the process anyway. In normal scenarios there's no real gain in security, because a failed index build would roll back the transaction leaving an unused index file, but for rebuilding shared system indexes this seems to add some useful protection.
* Repair some REINDEX problems per recent discussions. The relcache isTom Lane2003-09-241-48/+93
| | | | | | | | | | | | | now able to cope with assigning new relfilenode values to nailed-in-cache indexes, so they can be reindexed using the fully crash-safe method. This leaves only shared system indexes as special cases. Remove the 'index deactivation' code, since it provides no useful protection in the shared- index case. Require reindexing of shared indexes to be done in standalone mode, but remove other restrictions on REINDEX. -P (IgnoreSystemIndexes) now prevents using indexes for lookups, but does not disable index updates. It is therefore safe to allow from PGOPTIONS. Upshot: reindexing system catalogs can be done without a standalone backend for all cases except shared catalogs.
* This patch fixes a few missed GUC variables that were still upper case,Bruce Momjian2003-09-111-6/+7
| | | | | | | makes a few more small improvements to runtime.sgml, and makes some SGML conventions more consistent. Neil Conway
* Remove a bunch of content-free Diagnostics sections, as per previousTom Lane2003-09-091-16/+1
| | | | discussion. (Still have some work to do editing the remainder.)
* Add/edit index entries.Peter Eisentraut2003-08-311-1/+5
|
* Editing of more reference pages.Peter Eisentraut2003-04-261-193/+115
|
* Merge documentation into one book. (Build with "make html".) ReplacePeter Eisentraut2003-03-251-3/+2
| | | | vague cross-references with real links.
* This patch makes the following changes to the documentation:Bruce Momjian2003-02-191-12/+32
| | | | | | | | | | | | | - more work from the SGML police - some grammar improvements: rewriting a paragraph or two, replacing contractions where (IMHO) appropriate - fix missing utility commands in lock mode docs - improve CLUSTER, REINDEX, SET SESSION AUTHORIZATION ref pages Neil Conway
* Re-order REINDEX options in manual for consistency. REINDEXBruce Momjian2002-11-171-10/+10
| | | | DATABASE/TABLE/INDEX is the proper order.
* Add more appropriate markup.Peter Eisentraut2002-09-211-3/+4
|
* Mention REINDEX can be used for disk space reclaimation too.Bruce Momjian2002-06-231-1/+7
|
* Update SQL-command reference pages for schema features.Tom Lane2002-04-231-2/+3
|
* Augment the date/time examples in the User's Guide to reflect the newerThomas G. Lockhart2002-04-211-4/+2
| | | | | | | | | capabilities of specifying time zones as intervals per SQL9x. Put refentrytitle contents on the same line as the tag. Otherwise, leading whitespace is propagated into the product, which (at least) messes up the ToC layout. Remove (some) docinfo tags containing dates. Best to omit if the dates are not accurate; maybe use CVS dates instead or leave them out.
* Spell checking and markup additionsPeter Eisentraut2002-03-221-2/+2
|
* Use PostgreSQL consistantly throughout docs. Before, usage was split evenlyThomas G. Lockhart2001-12-081-3/+4
| | | | between Postgres and PostgreSQL.
* Further work on postmaster and postgres reference pages.Tom Lane2001-11-251-3/+5
|
* Add cross-reference to standalone-backend ref page.Tom Lane2001-11-251-1/+3
|
* Expand description of how to use REINDEX.Tom Lane2001-11-201-13/+98
|
* Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut2001-09-031-2/+2
|
* Add proofreader's changes to docs.Bruce Momjian2000-10-051-3/+3
| | | | Fix misspelling of disbursion to dispersion.
* spell cleanupsBruce Momjian2000-07-221-6/+6
|
* *** empty log message ***Hiroshi Inoue2000-03-311-0/+181
View Lorry Controller Status