summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2008-03-04Add URL for:Bruce Momjian
o Allow pg_restore to utilize multiple CPUs and I/O channels by restoring multiple objects simultaneously > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00963.php
2008-03-04Add ideas for concurrent pg_dump and pg_restore:Bruce Momjian
< * pg_dump > * pg_dump / pg_restore > o Allow pg_dump to utilize multiple CPUs and I/O channels by dumping > multiple objects simultaneously > > The difficulty with this is getting multiple dump processes to > produce a single dump output file. > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00205.php > > o Allow pg_restore to utilize multiple CPUs and I/O channels by > restoring multiple objects simultaneously > > This might require a pg_restore flag to indicate how many > simultaneous operations should be performed. Only pg_dump's > -Fc format has the necessary dependency information. > > o To better utilize resources, restore data, primary keys, and > indexes for a single table before restoring the next table > > Hopefully this will allow the CPU-I/O load to be more uniform > for simultaneous restores. The idea is to start data restores > for several objects, and once the first object is done, to move > on to its primary keys and indexes. Over time, simultaneous > data loads and index builds will be running. > > o To better utilize resources, allow pg_restore to check foreign > keys simultaneously, where possible > o Allow pg_restore to create all indexes of a table > concurrently, via a single heap scan > > This requires a pg_dump -Fc file because that format contains > the required dependency information. > http://archives.postgresql.org/pgsql-general/2007-05/msg01274.php > > o Allow pg_restore to load different parts of the COPY data > simultaneously < single heap scan, and have a restore of a pg_dump somehow use it > single heap scan, and have pg_restore use it < http://archives.postgresql.org/pgsql-general/2007-05/msg01274.php
2008-03-03Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2008-03-03Add:Bruce Momjian
> * Allow INSERT ... DELETE ... RETURNING, namely allow the DELETE ... > RETURNING to supply values to the INSERT > http://archives.postgresql.org/pgsql-hackers/2008-02/thrd2.php#00979
2008-03-03Add another URL for:Bruce Momjian
o Consider using a ring buffer for COPY FROM < < http://archives.postgresql.org/pgsql-hackers/2008-02/msg01080.php > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01080.php
2008-03-03Document that REVOKE doesn't remove all permissions if PUBLIC has permissions.Bruce Momjian
2008-03-03Add:Bruce Momjian
> > * Allow the UUID type to accept non-standard formats > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01214.php
2008-03-03Add:Bruce Momjian
> * Speed WAL recovery by allowing more than one page to be prefetched > > This involves having a separate process that can be told which pages > the recovery process will need in the near future. > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01279.php >
2008-03-03Remove "reliably" from chr(0) doc mention.Bruce Momjian
2008-03-03Document that chr(0) is not supported, and why.Bruce Momjian
2008-03-03Fix markup.Bruce Momjian
2008-03-03Add new FAQ item:Bruce Momjian
<H3 id="item1.15">1.15) How do I unsubscribe from the PostgreSQL email lists? How do I avoid receiving duplicate emails?</H3>
2008-03-03Add URL's for sequence discussions:Bruce Momjian
> > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00008.php > < o %Have ALTER TABLE RENAME rename SERIAL sequence names > o Have ALTER TABLE RENAME rename SERIAL sequence names > > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00008.php > > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00008.php
2008-02-29Update wording:Bruce Momjian
< * Add Oracle-style packages (Pavel) > * Add features of Oracle-style packages (Pavel)
2008-02-28Support for building contrib/uuid-ossp with MSVC.Magnus Hagander
Original patch from Hiroshi Saito, modified by me.
2008-02-26Add more clarification about SSH tunnels from Faheem Mitha.Peter Eisentraut
2008-02-26In the SSH setup instructions, changePeter Eisentraut
ssh -L 3333:foo.com:5432 joe@foo.com I think this should be changed to ssh -L 3333:localhost:5432 joe@foo.com The reason is that this assumes the postgres server on foo.com allows connections from foo.com, which is not allowed by the default listen_addresses setting. Add more detail explaining this. pointed out by Faheem Mitha Also change the example port number 3333 to 63333 so no one can complain that we are stealing a reserved port number.
2008-02-26Add information about format modifiers that apply to numeric formats.Peter Eisentraut
These were previously only documented in the context of date/time formats.
2008-02-23Change the declaration of struct varlena so that the length word isTom Lane
represented as "char ...[4]" not "int32". Since the length word is never supposed to be accessed via this struct member anyway, this won't break any existing code that is following the rules. The advantage is that C compilers will no longer assume that a pointer to struct varlena is word-aligned, which prevents incorrect optimizations in TOAST-pointer access and perhaps other places. gcc doesn't seem to do this (at least not at -O2), but the problem is demonstrable on some other compilers. I changed struct inet as well, but didn't bother to touch a lot of other struct definitions in which it wouldn't make any difference because there were other fields forcing int alignment anyway. Hopefully none of those struct definitions are used for accessing unaligned Datums.
2008-02-18Added --htmldir option to pg_config, equivalent to the new configure option.Peter Eisentraut
2008-02-17Upgrade to Autoconf 2.61:Peter Eisentraut
- Change configure.in to use Autoconf 2.61 and update generated files. - Update build system and documentation to support now directory variables offered by Autoconf 2.61. - Replace usages of PGAC_CHECK_ALIGNOF by AC_CHECK_ALIGNOF, now available in Autoconf 2.61. - Drop our patched version of AC_C_INLINE, as Autoconf now has the change.
2008-02-16Move item as done:Bruce Momjian
< > * -Allow AS in "SELECT col AS label" to be optional in certain cases > < * Allow AS in "SELECT col AS label" to be optional (not wanted)
2008-02-16Update docs to reflect the fact that we can now deal with DST rulesTom Lane
outside the 32-bit-time_t range. Also, refer to Olson's tz database as the 'zoneinfo' database, a name that upstream sometimes uses, not 'zic database' which they never use.
2008-02-16No need to use checkpoint_warning to log checkpoints --- we addedBruce Momjian
log_checkpoints in 8.3.
2008-02-16Add suggestion about how to set checkpoint_warning to log allBruce Momjian
checkpoints.
2008-02-15Allow AS to be omitted when specifying an output column name in SELECTTom Lane
(or RETURNING), but only when the output name is not any SQL keyword. This seems as close as we can get to the standard's syntax without a great deal of thrashing. Original patch by Hiroshi Saito, amended by me.
2008-02-13Correct XML markup typo, <book> -> </book>Bruce Momjian
XMLPARSE (DOCUMENT '<?xml version="1.0"?><book><title>Manual</title><chapter>...</chapter></book>') Backpatch to 8.3.X.
2008-02-13Add section to Migration talking about typical areas that change betweenBruce Momjian
major releases.
2008-02-12Fix SPI_cursor_open() and SPI_is_cursor_plan() to push the SPI stack beforeTom Lane
doing anything interesting, such as calling RevalidateCachedPlan(). The necessity of this is demonstrated by an example from Willem Buitendyk: during a replan, the planner might try to evaluate SPI-using functions, and so we'd better be in a clean SPI context. A small downside of this fix is that these two functions will now fail outright if called when not inside a SPI-using procedure (ie, a SPI_connect/SPI_finish pair). The documentation never promised or suggested that that would work, though; and they are normally used in concert with other functions, mainly SPI_prepare, that always have failed in such a case. So the odds of breaking something seem pretty low. In passing, make SPI_is_cursor_plan's error handling convention clearer, and fix documentation's erroneous claim that SPI_cursor_open would return NULL on error. Before 8.3 these functions could not invoke replanning, so there is probably no need for back-patching.
2008-02-08Some small editorialization on the protocol documentation for GSSAPI/SSPITom Lane
authentication.
2008-02-07Add "automatically" to HOT release note description.Bruce Momjian
2008-02-06Fix very broken clean.bat for msvc install. The way we used subroutinesMagnus Hagander
in .bat simply did not work, and it called them in the wrong order, some several times, and some not at all. So this unrolls all subroutine calls. This should fix the issues with clean deleting the wrong files reported by Dave Page. While at it, add the "clean dist" option to act like "make distclean", and no longer remove the flex/bison output files by default. This shuold fix the problem reported by Pavel Golub in bug #3909.
2008-02-03Fix mistaken duplicate reference to max_fsm_pages, per bug #3926.Tom Lane
Also make links clickable.
2008-02-02Minor wordsmithing in release notes' description of asynchronous commit.Tom Lane
2008-02-02Move example of turning off synchronous_commit to a more logical place,Tom Lane
to wit in the description of that variable rather than some other one.
2008-02-01Update FAQ for most recent release as 8.3.Bruce Momjian
2008-02-01Update item:Bruce Momjian
< * Improve deadlock detection when deleting items from shared buffers > * Improve deadlock detection when a page cleaning lock conflicts > with a shared buffer that is pinned
2008-01-31Fix spelling typo in comment.Bruce Momjian
2008-01-31Add comment about possible URL changes for www7.hp.com:Bruce Momjian
<!-- If this URL chnages replace it with a URL to www.archive.org. -->
2008-01-31Update spoofing /tmp symlink instructions to be more specific about theBruce Momjian
name of the needed symlink file.
2008-01-31Mention synchronize_seqscans GUC variable in release notes.Tom Lane
Update expected release date.
2008-01-31Remove the old table of "supported platforms" in favor of a link to theTom Lane
buildfarm plus a narrative description of the CPU types and operating systems on which Postgres is likely to work. Now that we've almost completely decoupled CPU and OS considerations, the former tabular style isn't all that enlightening anyway. Perhaps more importantly, no one seems particularly interested in maintaining the table by hand when we have the buildfarm.
2008-01-31Improve pg_autovacuum documentation to clarify that the enabled field cannotTom Lane
prevent anti-wraparound vacuuming, and to caution against setting unreasonably small values of freeze_max_age. Also put in a notice that this catalog is likely to disappear entirely in some future release. Per discussion of bug #3898 from Steven Flatt.
2008-01-31Document the idea of creating a symbolic link in /tmp to prevent serverBruce Momjian
spoofing when the socket file has been moved.
2008-01-31Add:Bruce Momjian
> * Improve deadlock detection when deleting items from shared buffers > > http://archives.postgresql.org/pgsql-bugs/2008-01/msg00138.php > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php > http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php
2008-01-30Add a GUC variable "synchronize_seqscans" to allow clients to disable the newTom Lane
synchronized-scanning behavior, and make pg_dump disable sync scans so that it will reliably preserve row ordering. Per recent discussions.
2008-01-30Improve table referencePeter Eisentraut
2008-01-30Update key words table for 8.3Peter Eisentraut
2008-01-29Update wording:Bruce Momjian
< * Add anonymous transactions > * Add autonomous transactions
2008-01-29Add item:Bruce Momjian
> * Add anonymous transactions > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php >
generated by cgit v1.2.3 (git 2.46.0) at 2025-09-23 21:54:03 +0000