user/sven/postgresql.git

Age	Commit message (Collapse)	Author
2012-02-22	Make EXPLAIN (BUFFERS) track blocks dirtied, as well as those written.	Robert Haas
	Also expose the new counters through pg_stat_statements. Patch by me. Review by Fujii Masao and Greg Smith.
2012-02-22	Improve wording of pg_upgrade logfile option:	Bruce Momjian
	-l, --logfile=FILENAME log internal activity to file\n\
2012-02-22	Draft release notes for 9.1.3, 9.0.7, 8.4.11, 8.3.18.	Tom Lane

2012-02-22	Add parameters for controlling locations of server-side SSL files	Peter Eisentraut
	This allows changing the location of the files that were previously hard-coded to server.crt, server.key, root.crt, root.crl. server.crt and server.key continue to be the default settings and are thus required to be present by default if SSL is enabled. But the settings for the server-side CA and CRL are now empty by default, and if they are set, the files are required to be present. This replaces the previous behavior of ignoring the functionality if the files were not found.
2012-02-19	Improve pretty printing of viewdefs.	Andrew Dunstan
	Some line feeds are added to target lists and from lists to make them more readable. By default they wrap at 80 columns if possible, but the wrap column is also selectable - if 0 it wraps after every item. Andrew Dunstan, reviewed by Hitoshi Harada.
2012-02-15	Make CREATE/ALTER FUNCTION support NOT LEAKPROOF.	Robert Haas
	Because it isn't good to be able to turn things on, and not off again.
2012-02-15	sepgsql: Reword and fix typo in docs on DML permissions.	Robert Haas
	Per report from Christoph Berg.
2012-02-14	Improve fsync documentation by stating that -W _0_ turns of write	Bruce Momjian
	caching.
2012-02-14	Document random page cost is only 4x seqeuntial, and not 40x.	Bruce Momjian

2012-02-14	Document that the pg_test_fsync defaults allow the program to complete	Bruce Momjian
	in about 30 seconds.
2012-02-14	Change contrib/pg_test_fsync to control tests in terms of seconds per	Bruce Momjian
	test, rather than a number of test cycles. Changes -o/cycles option to -s/seconds.
2012-02-13	Allow LEAKPROOF functions for better performance of security views.	Robert Haas
	We don't normally allow quals to be pushed down into a view created with the security_barrier option, but functions without side effects are an exception: they're OK. This allows much better performance in common cases, such as when using an equality operator (that might even be indexable). There is an outstanding issue here with the CREATE FUNCTION / ALTER FUNCTION syntax: there's no way to use ALTER FUNCTION to unset the leakproof flag. But I'm committing this as-is so that it doesn't have to be rebased again; we can fix up the grammar in a future commit. KaiGai Kohei, with some wordsmithing by me.
2012-02-09	psql: Support zero byte field and record separators	Peter Eisentraut
	Add new psql settings and command-line options to support setting the field and record separators for unaligned output to a zero byte, for easier interfacing with other shell tools. reviewed by Abhijit Menon-Sen
2012-02-07	Add opensp as a requirement for building the docs on Debian --- tested	Bruce Momjian
	on Debian Squeeze.
2012-02-07	Add TIMING option to EXPLAIN, to allow eliminating of timing overhead.	Robert Haas
	Sometimes it may be useful to get actual row counts out of EXPLAIN (ANALYZE) without paying the cost of timing every node entry/exit. With this patch, you can say EXPLAIN (ANALYZE, TIMING OFF) to get that. Tomas Vondra, reviewed by Eric Theise, with minor doc changes by me.
2012-02-07	createuser: Disable prompting by default	Peter Eisentraut
	Do not prompt when options were not specified. Assume --no-createdb, --no-createrole, --no-superuser by default. Also disable prompting for user name in dropdb, unless --interactive was specified. reviewed by Josh Kupershmidt
2012-02-04	Allow SQL-language functions to reference parameters by name.	Tom Lane
	Matthew Draper, reviewed by Hitoshi Harada
2012-02-04	Remove tabs in SGML file.	Bruce Momjian

2012-02-03	Add array_to_json and row_to_json functions.	Andrew Dunstan
	Also move the escape_json function from explain.c to json.c where it seems to belong. Andrew Dunstan, Reviewd by Abhijit Menon-Sen.
2012-02-01	initdb: Add options --auth-local and --auth-host	Peter Eisentraut
	reviewed by Robert Haas and Pavel Stehule
2012-02-01	Implement dry-run mode for pg_archivecleanup	Alvaro Herrera
	In dry-run mode, just the name of the file to be removed is printed to stdout; this is so the user can easily plug it into another program through a pipe. If debug mode is also specified, a more verbose message is printed to stderr. Author: Gabriele Bartolini Reviewer: Josh Kupershmidt
2012-01-31	Built-in JSON data type.	Robert Haas
	Like the XML data type, we simply store JSON data as text, after checking that it is valid. More complex operations such as canonicalization and comparison may come later, but this is enough for not. There are a few open issues here, such as whether we should attempt to detect UTF-8 surrogate pairs represented as \uXXXX\uYYYY, but this gets the basic framework in place.
2012-01-30	Add sequence USAGE privileges to information schema	Peter Eisentraut
	The sequence USAGE privilege is sufficiently similar to the SQL standard that it seems reasonable to show in the information schema. Also add some compatibility notes about it on the GRANT reference page.
2012-01-30	PL/Python: Add result metadata functions	Peter Eisentraut
	Add result object functions .colnames, .coltypes, .coltypmods to obtain information about the result column names and types, which was previously not possible in the PL/Python SPI interface. reviewed by Abhijit Menon-Sen
2012-01-28	Add caution about multiple unique indexes breaking plpgsql upsert example.	Tom Lane
	Per Phil Sorber, though I didn't use his wording exactly.
2012-01-28	Update statement about sorting of character-string data.	Tom Lane
	The sort order is no longer fixed at database creation time, but can be controlled via COLLATE. Noted by Thomas Kellerer.
2012-01-27	Use parameterized paths to generate inner indexscans more flexibly.	Tom Lane
	This patch fixes the planner so that it can generate nestloop-with- inner-indexscan plans even with one or more levels of joining between the indexscan and the nestloop join that is supplying the parameter. The executor was fixed to handle such cases some time ago, but the planner was not ready. This should improve our plans in many situations where join ordering restrictions formerly forced complete table scans. There is probably a fair amount of tuning work yet to be done, because of various heuristics that have been added to limit the number of parameterized paths considered. However, we are not going to find out what needs to be adjusted until the code gets some real-world use, so it's time to get it in there where it can be tested easily. Note API change for index AM amcostestimate functions. I'm not aware of any non-core index AMs, but if there are any, they will need minor adjustments.
2012-01-27	Document that COUNT(*) might not need a seq scan any more.	Robert Haas
	Noted by Josh Kupershmidt.
2012-01-27	Document that analyzing an empty table doesn't update the statistics.	Robert Haas
	Per a suggestion from Sergey Konoplev
2012-01-27	Fix copy-paste error in docs.	Heikki Linnakangas
	Dean Rasheed
2012-01-27	Fix wording, per Peter Geoghegan	Magnus Hagander

2012-01-27	Mention in the docs that bgwriter now sleeps longer when it has no work to do.	Heikki Linnakangas

2012-01-26	Fix sentence in docs: checkpoints are not done by bgwriter anymore.	Heikki Linnakangas

2012-01-26	Add deadlock counter to pg_stat_database	Magnus Hagander
	Adds a counter that tracks number of deadlocks that occurred in each database to pg_stat_database. Magnus Hagander, reviewed by Jaime Casanova
2012-01-26	Track temporary file count and size in pg_stat_database	Magnus Hagander
	Add counters for number and size of temporary files used for spill-to-disk queries for each database to the pg_stat_database view. Tomas Vondra, review by Magnus Hagander
2012-01-25	Allow pg_basebackup from standby node with safety checking.	Simon Riggs
	Base backup follows recommended procedure, plus goes to great lengths to ensure that partial page writes are avoided. Jun Ishizuka and Fujii Masao, with minor modifications
2012-01-25	Add pg_trigger_depth() function	Alvaro Herrera
	This reports the depth level of triggers currently in execution, or zero if not called from inside a trigger. No catversion bump in this patch, but you have to initdb if you want access to the new function. Author: Kevin Grittner
2012-01-24	Add new replication mode synchronous_commit = 'write'.	Simon Riggs
	Replication occurs only to memory on standby, not to disk, so provides additional performance if user wishes to reduce durability level slightly. Adds concept of multiple independent sync rep queues. Fujii Masao and Simon Riggs
2012-01-23	ALTER <thing> [IF EXISTS] ... allows silent DDL if required,	Simon Riggs
	e.g. ALTER FOREIGN TABLE IF EXISTS foo RENAME TO bar Pavel Stehule
2012-01-22	Typo fix	Magnus Hagander
	Guillaume Lelarge
2012-01-20	Get rid of itemizedlist inside table	Magnus Hagander
	This renders badly on the website, and in this particular case also doesn't actually add anything to the readability...
2012-01-20	Further doc cleanups from the pg_stat_activity changes	Magnus Hagander
	Fujii Masao
2012-01-19	Triggered change notifications.	Robert Haas
	Kevin Grittner, reviewed (in earlier versions) by Álvaro Herrera
2012-01-19	Clarify that bgwriter no longer handles checkpoints.	Robert Haas
	Text by Peter Geoghegan.
2012-01-19	Add bitwise AND, OR, and NOT operators for macaddr data type.	Robert Haas
	Brendan Jurd, reviewed by Fujii Masao
2012-01-19	Separate state from query string in pg_stat_activity	Magnus Hagander
	This separates the state (running/idle/idleintransaction etc) into it's own field ("state"), and leaves the query field containing just query text. The query text will now mean "current query" when a query is running and "last query" in other states. Accordingly,the field has been renamed from current_query to query. Since backwards compatibility was broken anyway to make that, the procpid field has also been renamed to pid - along with the same field in pg_stat_replication for consistency. Scott Mead and Magnus Hagander, review work from Greg Smith
2012-01-19	Make pg_relation_size() and friends return NULL if the object doesn't exist.	Heikki Linnakangas
	That avoids errors when the functions are used in queries like "SELECT pg_relation_size(oid) FROM pg_class", and a table is dropped concurrently. Phil Sorber
2012-01-18	PL/Python: Update example	Peter Eisentraut
	Change the usesavedplan() example to use a more modern Python style using the .setdefault() function.
2012-01-16	Disallow merging ONLY constraints in children tables	Alvaro Herrera
	When creating a child table, or when attaching an existing table as child of another, we must not allow inheritable constraints to be merged with non-inheritable ones, because then grandchildren would not properly get the constraint. This would violate the grandparent's expectations. Bugs noted by Robert Haas. Author: Nikhil Sontakke
2012-01-15	Allow a user to kill his own queries using pg_cancel_backend()	Magnus Hagander
	Allows a user to use pg_cancel_queries() to cancel queries in other backends if they are running under the same role. pg_terminate_backend() still requires superuser permissoins. Short patch, many authors working on the bikeshed: Magnus Hagander, Josh Kupershmidt, Edward Muller, Greg Smith.