aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Translation updatesPeter Eisentraut2004-02-12
|
* Add bitmap discussion to performance TODO.detail.Bruce Momjian2004-02-12
|
* Remove TODO.detail files that contained useless or very old information.Bruce Momjian2004-02-12
| | | | Update TODO accordingly.
* Done:Bruce Momjian2004-02-12
| | | | | | | | | < < < Reporting < ========= < < * Show location of syntax error in query [yacc]
* File not needed:Bruce Momjian2004-02-12
| | | | | | | | | | | .< * Improve speed with indexes (perhaps recreate index instead) [vacuum] > * Improve speed with indexes (perhaps recreate index instead) 369c369 < lock and truncate table [vacuum] > lock and truncate table 371c371 < rather than in /contrib [vacuum] > rather than in /contrib
* Mostly done:Bruce Momjian2004-02-12
| | | | < * Allow better handling of numeric constants, type conversion [typeconv]
* File not needed:Bruce Momjian2004-02-12
| | | | | < * Add replication of distributed databases [replication] > * Add replication of distributed databases
* Remove:Bruce Momjian2004-02-12
| | | | < o http://gborg.postgresql.org/project/pgreplication/projdisplay.php
* Merge files:Bruce Momjian2004-02-12
| | | | | | | | < * Allow persistent backends [persistent] > * Allow persistent backends [pool] 397c397 < connection pooling > connection pooling [pool]
* Not needed:Bruce Momjian2004-02-12
| | | | | | | | < float4, numeric/decimal too [optimizer] > float4, numeric/decimal too 422c422 < * Missing optimizer selectivities for date, r-tree, etc. [optimizer] > * Missing optimizer selectivities for date, r-tree, etc
* Not needed:Bruce Momjian2004-02-12
| | | | | < * Delay fsync() when other backends are about to commit too [fsync] > * Delay fsync() when other backends are about to commit too
* Not needed:Bruce Momjian2004-02-12
| | | | | < * Add MATCH PARTIAL referential integrity [foreign] > * Add MATCH PARTIAL referential integrity
* Remove crossdb content.Bruce Momjian2004-02-12
|
* Add, dblink doesn't do this:Bruce Momjian2004-02-12
| | | | > * Allow cross-db queries with transaction sematics
* Done, mostly by dblink, I think:Bruce Momjian2004-02-12
| | | | < * Allow queries across multiple databases [crossdb]
* Fix typo:Bruce Momjian2004-02-12
| | | | | | | | | | | | | | | | | | | On Mon, 2004-01-26 at 21:28, Peter Eisentraut wrote: > Christophe Combelles wrote: > > At the bottom of this doc file : > > file:///usr/share/doc/postgresql-doc/html/tutorial-createdb.html > > "and it also happens that that user always has permission" > > ---- x2 > The first "that" serves as a conjuction, the second one serves as an > article. Looks correct to me. A better workaround for the sentence would be something like: "and it also happens that the user always has permission" Looks easier to read, I think. Enver ALTIN (a.k.a. skyblue)
* Add:Bruce Momjian2004-02-12
| | | | | < > * Allow substring/replace() to get/set bit values
* Fixed bug where FlushRelationBuffers() did call StrategyInvalidateBuffer()Jan Wieck2004-02-12
| | | | | | | | | | | for already empty buffers because their buffer tag was not cleard out when the buffers have been invalidated before. Also removed the misnamed BM_FREE bufhdr flag and replaced the checks, which effectively ask if the buffer is unpinned, with checks against the refcount field. Jan
* Remove URL for specific pljava implementation:Bruce Momjian2004-02-12
| | | | | | < o Allow Java server-side programming, http://pljava.sourceforge.net < [java] > o Allow Java server-side programming [java]
* Check only live tuples for OID validity, to avoid issues after ALTERTom Lane2004-02-12
| | | | TABLE. Per recent discussion.
* Added hints about the reason, why the command string inJan Wieck2004-02-12
| | | | | | the view pg_stat_activity is missing, as per Bruces suggestion. Jan
* Commit the reasonably uncontroversial parts of J.R. Nield's PITR patch, toTom Lane2004-02-11
| | | | | | | | | | | wit: Add a header record to each WAL segment file so that it can be reliably identified. Avoid splitting WAL records across segment files (this is not strictly necessary, but makes it simpler to incorporate the header records). Make WAL entries for file creation, deletion, and truncation (as foreseen but never implemented by Vadim). Also, add support for making XLOG_SEG_SIZE configurable at compile time, similarly to BLCKSZ. Fix a couple bugs I introduced in WAL replay during recent smgr API changes. initdb is forced due to changes in pg_control contents.
* Repair some problems in bgwriter start/stop logic. In particular, don'tTom Lane2004-02-11
| | | | | | | allow the bgwriter to start before the startup subprocess has finished ... it tends to crash otherwise. (The same problem may have existed for the checkpointer, I'm not entirely sure.) Remove some code that was redundant because the bgwriter is handled as a member of the backend list.
* Add:Bruce Momjian2004-02-11
| | | | > o Disallow dropping of an inherited constraint
* Check and set thread-safe functions separately, rather than as a singleBruce Momjian2004-02-11
| | | | | | | | | | variable. Remove thread locking for non-thread-safe functions, instead throw a compile error. Platforms will have to re-run tools/thread to record their thread safety.
* Properly set NEED_REENTRANT_FUNCS for threaded libpq/ecpg.Bruce Momjian2004-02-11
| | | | Without this patch, no thread locking or *_r functions were being used.
* Does not apply anymore:Bruce Momjian2004-02-11
| | | | < * Make blind writes go through the file descriptor cache
* No need to link libpq into these programs ...Tom Lane2004-02-10
|
* SGML markup improvements.Neil Conway2004-02-10
|
* Add configure support for determining UINT64_FORMAT, the appropriateTom Lane2004-02-10
| | | | snprintf format for uint64 items.
* More clearly describe why PQinSend returns false for non-threaded libpq.Bruce Momjian2004-02-10
|
* Add URL for most current version.Bruce Momjian2004-02-10
|
* Repair missing inclusions of -lintl for shared libraries.Tom Lane2004-02-10
|
* Looks like we need <unistd.h> for select() on Darwin.Tom Lane2004-02-10
|
* Centralize implementation of delay code by creating a pg_usleep()Tom Lane2004-02-10
| | | | | | | | | subroutine in src/port/pgsleep.c. Remove platform dependencies from miscadmin.h and put them in port.h where they belong. Extend recent vacuum cost-based-delay patch to apply to VACUUM FULL, ANALYZE, and non-btree index vacuuming. By the way, where is the documentation for the cost-based-delay patch?
* Restructure smgr API as per recent proposal. smgr no longer depends onTom Lane2004-02-10
| | | | | | | | | the relcache, and so the notion of 'blind write' is gone. This should improve efficiency in bgwriter and background checkpoint processes. Internal restructuring in md.c to remove the not-very-useful array of MdfdVec objects --- might as well just use pointers. Also remove the long-dead 'persistent main memory' storage manager (mm.c), since it seems quite unlikely to ever get resurrected.
* Win32 signals cleanup. Patch by Magnus Hagander, with input from ClaudioNeil Conway2004-02-08
| | | | | | | | | | | | | | | | | | | | | | Natoli and Bruce Momjian (and some cosmetic fixes from Neil Conway). Changes: - remove duplicate signal definitions from pqsignal.h - replace pqkill() with kill() and redefine kill() in Win32 - use ereport() in place of fprintf() in some error handling in pqsignal.c - export pg_queue_signal() and make use of it where necessary - add a console control handler for Ctrl-C and similar handling on Win32 - do WaitForSingleObjectEx() in CHECK_FOR_INTERRUPTS() on Win32; query cancelling should now work on Win32 - various other fixes and cleanups
* Add mention of the developer's FAQ.Bruce Momjian2004-02-08
|
* Add mention of PostgreSQL as a community project.Bruce Momjian2004-02-08
|
* Add PITR web page:Bruce Momjian2004-02-08
| | | | | | | | < * Point-in-time data recovery using backup and write-ahead log < * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/win32.html > * Point-in-time data recovery using backup and write-ahead log, > http://momjian.postgresql.org/main/writings/pgsql/project/pitr.html > * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/project/win32.html
* Add missing dependency, per Wade Klaver.Tom Lane2004-02-07
|
* Cost based vacuum delay feature.Jan Wieck2004-02-06
| | | | Jan
* Documentation for generate_series() functions committed a few days ago.Joe Conway2004-02-05
|
* Backing out the background writer sync() option.Jan Wieck2004-02-04
| | | | Jan
* Use memmove() rather than memcpy() in set_var_from_var(). If this functionNeil Conway2004-02-04
| | | | | | | is asked to assign a variable to itself, it will result in doing a memcpy() on an entirely-overlapping memory range, which results in undefined behavior according to ANSI C. That said, it is unlikely to actually do anything bad on any sane libc, but this keeps valgrind quiet.
* pwdTom Lane2004-02-03
|
* Rename SortMem and VacuumMem to work_mem and maintenance_work_mem.Tom Lane2004-02-03
| | | | | | | Make btree index creation and initial validation of foreign-key constraints use maintenance_work_mem rather than work_mem as their memory limit. Add some code to guc.c to allow these variables to be referenced by their old names in SHOW and SET commands, for backwards compatibility.
* Add:Bruce Momjian2004-02-03
| | | | > * Make pg_restore continue after errors, so it acts more like pg_dump scripts
* Add function (actually an int4 and an int8 version) that generatesJoe Conway2004-02-03
| | | | | | | | a series of numbers, optionally using an explicit step size other than the default value (one). Use function in the information_schema to replace hard-wired knowledge of INDEX_MAX_KEYS. initdb forced due to pg_proc change. Documentation update still needed -- will be committed separately.
* Win32 adjustments for dirmod and configure/configure.in.Bruce Momjian2004-02-02
|