aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Mark Greg as the instigator of the statistics target increase:Bruce Momjian2009-03-27
| | | | | Increase the default value of default_statistics_target from 10 to 100 (Greg Sabino Mullane, Tom)
* First round of release note changes from Guillaume Smet.Bruce Momjian2009-03-27
|
* Fix release note attribution:Bruce Momjian2009-03-27
| | | | | | | Support the IS0 8601 time interval syntax (Tom, Kevin Grittner) per Ron Mayer
* Improved release notes interval wording:Bruce Momjian2009-03-27
| | | | | | | Made interval seconds rounding more consistent across output formats (Ron Mayer) Ron Mayer
* Remove duplicate interval (fractional seconds) items; Ron MayerBruce Momjian2009-03-27
|
* Document that Datestyle no longer controls interval output, perBruce Momjian2009-03-27
| | | | suggestion from Ron Mayer
* Make pg_standby's maxretries option do what one would expect. Fujii MasaoTom Lane2009-03-26
|
* Gettext plural supportPeter Eisentraut2009-03-26
| | | | | | In the backend, I changed only a handful of exemplary or important-looking instances to make use of the plural support; there is probably more work there. For the rest of the source, this should cover all relevant cases.
* Fix a couple of places that still claimed LC_COLLATE and LC_CTYPE can'tTom Lane2009-03-26
| | | | be changed after initdb.
* Adjust phrasing of complaints about multi-byte COPY delimiter strings.Tom Lane2009-03-26
| | | | Per pgsql-hackers discussion of 2009-02-17.
* If we expect a hash join to be performed in multiple batches, suppressTom Lane2009-03-26
| | | | | | | | "physical tlist" optimization on the outer relation (ie, force a projection step to occur in its scan). This avoids storing useless column values when the outer relation's tuples are written to temporary batch files. Modified version of a patch by Michael Henderson and Ramon Lawrence.
* Correction: ansi-join ->anti-join.Bruce Momjian2009-03-26
|
* Fix markup so that 'make HISTORY' works. A couple very minorTom Lane2009-03-26
| | | | editorial improvements.
* Reorder 8.4 release note sections.Bruce Momjian2009-03-26
|
* Re-add release notes for release 8.3.7.Bruce Momjian2009-03-26
|
* Adjust AS OF release notes markup.Bruce Momjian2009-03-26
|
* Mention release note items current as of 2009-03-16.Bruce Momjian2009-03-26
|
* First version of 8.4 release notes; markup/cleanup/reorganization stillBruce Momjian2009-03-26
| | | | required.
* Add btree_gin contrib module.Tom Lane2009-03-25
| | | | Teodor Sigaev and Oleg Bartunov
* Adjust the APIs for GIN opclass support functions to allow the extractQuery()Tom Lane2009-03-25
| | | | | | | | | | | | | | method to pass extra data to the consistent() and comparePartial() methods. This is the core infrastructure needed to support the soon-to-appear contrib/btree_gin module. The APIs are still upward compatible with the definitions used in 8.3 and before, although *not* with the previous 8.4devel function definitions. catversion bump for changes in pg_proc entries (although these are just cosmetic, since GIN doesn't actually look at the function signature before calling it...) Teodor Sigaev and Oleg Bartunov
* Fix old thinko in pgp.h: the idea is to declare some named enum types,Tom Lane2009-03-25
| | | | | | | | not global variables of anonymous enum types. This didn't actually hurt much because most linkers will just merge the duplicated definitions ... but some will complain. Per bug #4731 from Ceriel Jacobs. Backpatch to 8.1 --- the declarations don't exist before that.
* Use double quotes instead of single quotes.Peter Eisentraut2009-03-25
|
* Complete list of valid fork names, and use double quotes.Peter Eisentraut2009-03-25
|
* Update line count for \? output (obtained from wc -l)Peter Eisentraut2009-03-25
|
* In the \? output, align the columns consistently.Peter Eisentraut2009-03-25
|
* Polish SQL/MED terminologyPeter Eisentraut2009-03-25
|
* No period if it's not a sentencePeter Eisentraut2009-03-25
|
* Install a search tree depth limit in GIN bulk-insert operations, to preventTom Lane2009-03-24
| | | | | | | | | | | | them from degrading badly when the input is sorted or nearly so. In this scenario the tree is unbalanced to the point of becoming a mere linked list, so insertions become O(N^2). The easiest and most safely back-patchable solution is to stop growing the tree sooner, ie limit the growth of N. We might later consider a rebalancing tree algorithm, but it's not clear that the benefit would be worth the cost and complexity. Per report from Sergey Burladyan and an earlier complaint from Heikki. Back-patch to 8.2; older versions didn't have GIN indexes.
* Fix stupid parenthesization mistake. Per bug #4728 from Bruce Toll.Tom Lane2009-03-24
|
* Implement "fastupdate" support for GIN indexes, in which we try to accumulateTom Lane2009-03-24
| | | | | | | | | | | | | | | | | | multiple index entries in a holding area before adding them to the main index structure. This helps because bulk insert is (usually) significantly faster than retail insert for GIN. This patch also removes GIN support for amgettuple-style index scans. The API defined for amgettuple is difficult to support with fastupdate, and the previously committed partial-match feature didn't really work with it either. We might eventually figure a way to put back amgettuple support, but it won't happen for 8.4. catversion bumped because of change in GIN's pg_am entry, and because the format of GIN indexes changed on-disk (there's a metapage now, and possibly a pending list). Teodor Sigaev
* Fix my typoPeter Eisentraut2009-03-24
|
* Remove munging of xml and xpath params to xpath(). The XML must now be a ↵Andrew Dunstan2009-03-23
| | | | well formed XML document.
* Const-ify the parse table passed to fillRelOptions. The previous codingTom Lane2009-03-23
| | | | meant it had to be built on-the-fly at each entry to default_reloptions.
* Update constraint_exclusion docs because parameter is now 3-valued, notBruce Momjian2009-03-23
| | | | just enable/disable.
* Add expected file for locale-enabled installations.Peter Eisentraut2009-03-23
|
* More fixes for 8.4 DTrace probes. Remove useless BUFFER_HIT/BUFFER_MISSTom Lane2009-03-23
| | | | | | | probes --- the BUFFER_READ_DONE probe provides the same information and more besides. Expand the LOCK_WAIT_START/DONE probe arguments so that there's actually some chance of telling what is being waited for. Update and clean up the documentation.
* Clarify libpq 'sslverify' documentation wording.Bruce Momjian2009-03-23
|
* Add isExtend to the parameters of the buffer_read_start and buffer_read_doneTom Lane2009-03-22
| | | | | | | | | | | | | | | DTrace probes, so that ordinary reads can be distinguished from relation extension operations. Move buffer_read_start probe to before the smgrnblocks() call that's needed in the isExtend case, since really that step should be charged as part of the time needed for the extension operation. (This makes it slightly harder to match the read_start with the associated read_done, since now you can't match them on blockNumber, but it should still be possible since isExtend operations on the same relation can never be interleaved.) Per recent discussion. In passing, add the page identity (forkNum/blockNum) to the parameters of the buffer_flush_start/buffer_flush_done probes, which were unaccountably lacking the info.
* Clarify 'cert' authentication documention.Bruce Momjian2009-03-22
|
* Clean up pg_SSPI_error() coding a little bit: make the messages moreTom Lane2009-03-22
| | | | | consistent, translate where intended, const-ify declarations. Resolves a gripe from Alvaro as well as some stuff I didn't like.
* Remove the -d and -D options of pg_dump and pg_dumpall. The functionalityTom Lane2009-03-22
| | | | | | | is still available, but you must now write the long equivalent --inserts or --column-inserts. This change is made to eliminate confusion with the use of -d to specify a database name in most other Postgres client programs. Original patch by Greg Mullane, modified per subsequent discussion.
* Remove the datetime keywords ABSTIME and RELTIME, which we'd been treating asTom Lane2009-03-22
| | | | | | | | noise words for the last twelve years, for compatibility with Berkeley-era output formatting of the special INVALID values for those datatypes. Considering that the datatypes themselves have been deprecated for awhile, this is taking backwards compatibility a little far. Per gripe from Josh Berkus.
* Optimize multi-batch hash joins when the outer relation has a nonuniformTom Lane2009-03-21
| | | | | | | | | distribution, by creating a special fast path for the (first few) most common values of the outer relation. Tuples having hashvalues matching the MCVs are effectively forced to be in the first batch, so that we never write them out to the batch temp files. Bryce Cutt and Ramon Lawrence, with some editorialization by me.
* Rename pg_restore -m to -j, and add documentation about what good numbersPeter Eisentraut2009-03-20
| | | | are. per discussion on hackers
* Don't set the signal handler for SIGQUIT on Windows. Buildfarm shows thatHeikki Linnakangas2009-03-18
| | | | | | | reinstalling the default signal handler doesn't work as it is on Windows. Presumably core dumps on SIGQUIT are not a problem on Windows, so rather than figure out what header files or other changes are required to make it work, just don't bother.
* Be more clear about when to use gist__int_ops vs. gist__intbig_ops.Tom Lane2009-03-18
| | | | Per suggestion from Ron Mayer.
* Don't intercept SIGQUIT as a signal to trigger failover; that's whatHeikki Linnakangas2009-03-18
| | | | | | | postmaster uses for immediate shutdown. Trap SIGUSR1 as the preferred signal for that. Per report by Fujii Masao and subsequent discussion on -hackers.
* Fix case of the just resurrected UCS_to_BIG5.pl script, and updateHeikki Linnakangas2009-03-18
| | | | Makefile to use it.
* Add seven kanji characters defined in the Windows 950 codepage to ourHeikki Linnakangas2009-03-18
| | | | | | big5/win950 <-> UTF8 conversion tables. Per report by Roger Chang.
* Fix Windows-specific race condition in syslogger. This could've beenHeikki Linnakangas2009-03-18
| | | | | | | | | | | the cause of the "could not write to log file: Bad file descriptor" errors reported at http://archives.postgresql.org//pgsql-general/2008-06/msg00193.php Backpatch to 8.3, the race condition was introduced by the CSV logging patch. Analysis and patch by Gurjeet Singh.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 12:09:32 +0000