summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-11-03Role membership of superusers is only by explicit membership for HBA.Andrew Dunstan
Document that this rule applies to 'samerole' as well as to named roles. Per gripe from Tom Lane.
2011-11-03Do not treat a superuser as a member of every role for HBA purposes.Andrew Dunstan
This makes it possible to use reject lines with group roles. Andrew Dunstan, reviewd by Robert Haas.
2011-11-03Support range data types.Heikki Linnakangas
Selectivity estimation functions are missing for some range type operators, which is a TODO. Jeff Davis
2011-11-03Improve docs for timing and skipping of checkpointsSimon Riggs
Greg Smith
2011-11-01Document that multiple LDAP servers can be specifiedMagnus Hagander
2011-10-28Clarify that ORDER BY/FOR UPDATE can't malfunction at higher iso levels.Robert Haas
Kevin Grittner
2011-10-28Change "and and" to "and".Robert Haas
Report by Vik Reykja, patch by Kevin Grittner.
2011-10-26Typo fixes.Tom Lane
expect -> except, noted by Andrew Dunstan. Also, "cannot" seems more readable here than "can not", per David Wheeler.
2011-10-26Implement streaming xlog for backup toolsMagnus Hagander
Add option for parallel streaming of the transaction log while a base backup is running, to get the logfiles before the server has removed them. Also add a tool called pg_receivexlog, which streams the transaction log into files, creating a log archive without having to wait for segments to complete, thus decreasing the window of data loss without having to waste space using archive_timeout. This works best in combination with archive_command - suggested usage docs etc coming later.
2011-10-25Fix typoMagnus Hagander
2011-10-25Support configurable eventlog application names on WindowsMagnus Hagander
This allows different instances to use the eventlog with different identifiers, by setting the event_source GUC, similar to how syslog_ident works. Original patch by MauMau, heavily modified by Magnus Hagander
2011-10-22Support synchronization of snapshots through an export/import procedure.Tom Lane
A transaction can export a snapshot with pg_export_snapshot(), and then others can import it with SET TRANSACTION SNAPSHOT. The data does not leave the server so there are not security issues. A snapshot can only be imported while the exporting transaction is still running, and there are some other restrictions. I'm not totally convinced that we've covered all the bases for SSI (true serializable) mode, but it works fine for lesser isolation modes. Joachim Wieland, reviewed by Marko Tiikkaja, and rather heavily modified by Tom Lane
2011-10-19Document that postmaster.opts is excluded from base backupsRobert Haas
Fujii Masao
2011-10-18Make the CHECKPOINT reference page more clear.Robert Haas
Josh Kupershmidt, reviewed by Fujii Masao
2011-10-16Avoid assuming that index-only scan data matches the index's rowtype.Tom Lane
In general the data returned by an index-only scan should have the datatypes originally computed by FormIndexDatum. If the index opclasses use "storage" datatypes different from their input datatypes, the scan tuple will not have the same rowtype attributed to the index; but we had a hard-wired assumption that that was true in nodeIndexonlyscan.c. We'd already hacked around the issue for the one case where the types are different in btree indexes (btree name_ops), but this would definitely come back to bite us if we ever implement index-only scans in GiST. To fix, require the index AM to explicitly provide the tupdesc for the tuple it is returning. btree can just pass back the index's tupdesc, but GiST will have to work harder when and if it supports index-only scans. I had previously proposed fixing this by allowing the index AM to fill the scan tuple slot directly; but on reflection that seemed like a module layering violation, since TupleTableSlots are creatures of the executor. At least in the btree case, it would also be less efficient, since the tuple deconstruction work would occur even for rows later found to be invisible to the scan's snapshot.
2011-10-16Teach btree to handle ScalarArrayOpExpr quals natively.Tom Lane
This allows "indexedcol op ANY(ARRAY[...])" conditions to be used in plain indexscans, and particularly in index-only scans.
2011-10-15Marginal improvements to documentation of plpgsql's OPEN cursor statement.Tom Lane
Rearrange text to improve clarity, and add an example of implicit reference to a plpgsql variable in a bound cursor's query. Byproduct of some work I'd done on the "named cursor parameters" patch before giving up on it.
2011-10-15Document that is the psql version number, not the server version number,Bruce Momjian
that controls .psqlrc.
2011-10-15Improve doc wording of drop table permission.Bruce Momjian
2011-10-14Allow a major PG version psql .psqlrc file to be used if a minorBruce Momjian
matching version file does not exist. This avoids needing to rename .psqlrc files after minor version upgrades.
2011-10-14Measure the number of all-visible pages for use in index-only scan costing.Tom Lane
Add a column pg_class.relallvisible to remember the number of pages that were all-visible according to the visibility map as of the last VACUUM (or ANALYZE, or some other operations that update pg_class.relpages). Use relallvisible/relpages, instead of an arbitrary constant, to estimate how many heap page fetches can be avoided during an index-only scan. This is pretty primitive and will no doubt see refinements once we've acquired more field experience with the index-only scan mechanism, but it's way better than using a constant. Note: I had to adjust an underspecified query in the window.sql regression test, because it was changing answers when the plan changed to use an index-only scan. Some of the adjacent tests perhaps should be adjusted as well, but I didn't do that here.
2011-10-13Document actual string that has to be returned by the client for MD5Bruce Momjian
authentication. Report and pseudo code by Cyan Ogilvie
2011-10-13Remove all "traces" of trace_userlocks, because userlocks were removedBruce Momjian
in PG 8.2.
2011-10-13Update documentation about ts_rank().Bruce Momjian
2011-10-13Have pg_ctl return an exit status of 3 if the server is not running, toBruce Momjian
match the Linux Standard Base Core Specification 3.1. Aaron W. Swenson
2011-10-13Fix typo in dummy_seclabel documentation.Tom Lane
dummy_label -> dummy_seclabel Thom Brown
2011-10-13Document who can drop a table (owner and user with permissions).Bruce Momjian
2011-10-13Remove tab in sgml file.Bruce Momjian
2011-10-12Document how to accent Alvaro Herrera in the release notes.Bruce Momjian
2011-10-12Clarify wording of foreign key documentation to mention null entries asBruce Momjian
not matching the primary key. Report from Marek.Balgar@seznam.cz
2011-10-12Throw a useful error message if an extension script file is fed to psql.Tom Lane
We have seen one too many reports of people trying to use 9.1 extension files in the old-fashioned way of sourcing them in psql. Not only does that usually not work (due to failure to substitute for MODULE_PATHNAME and/or @extschema@), but if it did work they'd get a collection of loose objects not an extension. To prevent this, insert an \echo ... \quit line that prints a suitable error message into each extension script file, and teach commands/extension.c to ignore lines starting with \echo. That should not only prevent any adverse consequences of loading a script file the wrong way, but make it crystal clear to users that they need to do it differently now. Tom Lane, following an idea of Andrew Dunstan's. Back-patch into 9.1 ... there is not going to be much value in this if we wait till 9.2.
2011-10-12Modify up/home macro to match standard parameter list; fixes doc build.Bruce Momjian
2011-10-12Improve documentation of psql's \q command.Tom Lane
The documentation neglected to explain its behavior in a script file (it only ends execution of the script, not psql as a whole), and failed to mention the long form \quit either.
2011-10-12Add Up/Home link to the top of the HTML doc output.Bruce Momjian
Backpatch to 9.0.X and 9.1.X.
2011-10-11Document that not backing up postmaster.pid and postmaster.opts mightBruce Momjian
help prevent pg_ctl from getting confused. Backpatch to 9.1.
2011-10-10Make the reference to "CREATE USER" in the CREATE ROLE page a link.Robert Haas
This might help to avoid confusion between the CREATE USER command, and the deprecated CREATEUSER option to CREATE ROLE, as per a recent complaint from Ron Adams. At any rate, having a cross-link here seems like a good idea; two commands that are so similar should reference each other.
2011-10-10Improve documentation of how to fiddle with SCSI drives on FreeBSD.Robert Haas
Per suggestions from Achilleas Mantzios and Greg Smith.
2011-10-10Fix typo in docs for libpq keepalives_count option.Robert Haas
Shigehiro Honda
2011-10-10Add doc index entry for pg_resetxlog.Robert Haas
Fujii Masao
2011-10-10Document DELETE/UPDATE command tag behavior when triggers are involved.Robert Haas
Marti Raudsepp
2011-10-10Some minor wordsmithing for the cascading replication documentation.Robert Haas
Per report from Thom Brown.
2011-10-10In pg_upgrade, add -o/-O options to pass parameters to the servers, andBruce Momjian
document its use for config-only directory installs.
2011-10-09Improve index-only scans to avoid repeated access to the index page.Tom Lane
We copy all the matched tuples off the page during _bt_readpage, instead of expensively re-locking the page during each subsequent tuple fetch. This costs a bit more local storage, but not more than 2*BLCKSZ worth, and the reduction in LWLock traffic is certainly worth that. What's more, this lets us get rid of the API wart in the original patch that said an index AM could randomly decline to supply an index tuple despite having asserted pg_am.amcanreturn. That will be important for future improvements in the index-only-scan feature, since the executor will now be able to rely on having the index data available.
2011-10-08Note that index-only scans can affect idx_tup_fetch.Tom Lane
An index-only scan that avoids heap fetches will increment idx_tup_read but not idx_tup_fetch.
2011-10-07Add missing space.Robert Haas
Dickson S. Guedes
2011-10-07Support index-only scans using the visibility map to avoid heap fetches.Tom Lane
When a btree index contains all columns required by the query, and the visibility map shows that all tuples on a target heap page are visible-to-all, we don't need to fetch that heap page. This patch depends on the previous patches that made the visibility map reliable. There's a fair amount left to do here, notably trying to figure out a less chintzy way of estimating the cost of an index-only scan, but the core functionality seems ready to commit. Robert Haas and Ibrar Ahmed, with some previous work by Heikki Linnakangas.
2011-10-06Move pg_upgrade doc mention of the port numbers to the same place.Bruce Momjian
2011-10-06Add postmaster -C option to query configuration parameters, and haveBruce Momjian
pg_ctl use that to query the data directory for config-only installs. This fixes awkward or impossible pg_ctl operation for config-only installs.
2011-10-04Change wording for COALESCE docs to use "otherwise".Bruce Momjian
Per Tom
2011-10-04Explain COALESCE example in the docs.Bruce Momjian
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-28 12:34:09 +0000