summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2008-03-28Done:Bruce Momjian
> * -Add ability to trigger on TRUNCATE
2008-03-28Clarify documentation on PITR and warm standby on the fact that the standbyHeikki Linnakangas
restore_command should report failure on non-existent .backup and .history files. Tidy up some related text along the way. Patch by Markus Bertheau, with some editing by Simon Riggs and myself.
2008-03-28Add to TODO:Bruce Momjian
> > o Add CASE capability to language (already in SQL) > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00696.php > >
2008-03-28Add:Bruce Momjian
> * Allow one transaction to see tuples using the snapshot of another > transaction > > This would assist multiple backends in working together. > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00400.php
2008-03-28Support statement-level ON TRUNCATE triggers. Simon RiggsTom Lane
2008-03-27Add to TODO:Bruce Momjian
> > * Consider being smarter about memory and external files used during > sorts > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg01101.php > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00045.php
2008-03-27Add URL for:Bruce Momjian
* Consider allowing control of upper/lower case folding of unquoted identifiers > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00849.php
2008-03-27Remove ipcclean utility command --- didn't work on all Unixes and onBruce Momjian
Windows. Users should use their operating system tools instead.
2008-03-26Fix bad spelling and worse grammar in recent doc commits. PropagateTom Lane
pg_dump --ignore-version comments into pg_dumpall and pg_restore pages.
2008-03-26Improve documentation for odd array slice behavior.Bruce Momjian
2008-03-26Strengthen warnings about using pg_dump's -i option.Bruce Momjian
2008-03-26Update TODO:Bruce Momjian
< o Consider invalidating the cache or keeping seperate cached < copies when search_path changes > o Consider keeping seperate cached copies when search_path changes
2008-03-26Added to TODO:Bruce Momjian
> > * Consider transaction start/end performance improvements > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00948.php > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00361.php
2008-03-25Update documentation for recent DTrace changes. Patch from Robert Lor.Neil Conway
2008-03-25Simplify and standardize conversions between TEXT datums and ordinary CTom Lane
strings. This patch introduces four support functions cstring_to_text, cstring_to_text_with_len, text_to_cstring, and text_to_cstring_buffer, and two macros CStringGetTextDatum and TextDatumGetCString. A number of existing macros that provided variants on these themes were removed. Most of the places that need to make such conversions now require just one function or macro call, in place of the multiple notational layers that used to be needed. There are no longer any direct calls of textout or textin, and we got most of the places that were using handmade conversions via memcpy (there may be a few still lurking, though). This commit doesn't make any serious effort to eliminate transient memory leaks caused by detoasting toasted text objects before they reach text_to_cstring. We changed PG_GETARG_TEXT_P to PG_GETARG_TEXT_PP in a few places where it was easy, but much more could be done. Brendan Jurd and Tom Lane
2008-03-25Done:Bruce Momjian
> * -Avoid tuple some tuple copying in sort routines
2008-03-25Update TODO wording:Bruce Momjian
* Simplify integer cross-data-type operators
2008-03-25Add to TODO:Bruce Momjian
> > * Add SQL-standard array_agg() and unnest() array functions > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01017.php >
2008-03-25Add to pl/pgsql TODO:Bruce Momjian
> > o Consider invalidating the cache or keeping seperate cached > copies when search_path changes > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01009.php
2008-03-25Add to TODO:Bruce Momjian
> > * Add more cross-data-type operators > > http://archives.postgresql.org/pgsql-bugs/2008-01/msg00189.php
2008-03-25Add to TODO:Bruce Momjian
> * Detect deadlocks involving LockBufferForCleanup() > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php
2008-03-25Add to psql TODO:Bruce Momjian
> > o Improve display if enums > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00826.php > >
2008-03-25Add to TODO:Bruce Momjian
> > o Fix port/rint.c to be spec-compliant > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00808.php
2008-03-25Add to TODO:Bruce Momjian
> > * Consider sorting entries before inserting into btree index > > http://archives.postgresql.org/pgsql-general/2008-01/msg01010.php
2008-03-25Add to TODO:Bruce Momjian
> > * Improve detection of shared memory segments being used by other > FreeBSD jails > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00656.php
2008-03-25Add to TODO:Bruce Momjian
> > * Move pgfoundry's xlogdump to /contrib and have it rely more closely > on the WAL backend code > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00035.php >
2008-03-25Add to TODO:Bruce Momjian
> > * Have resource managers report the duration of their status changes > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg01468.php
2008-03-25Add to TODO:Bruce Momjian
> > * Be more aggressive about creating WAL files > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg01325.php
2008-03-25Add:Bruce Momjian
> o Prevent concurrent CREATE TABLE table1 from sometimes returning > a cryptic error message > > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00169.php
2008-03-25Add to TODO:Bruce Momjian
> > * Have /contrib/dblink reuse unnamed connections > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00895.php
2008-03-25Add to TODO:Bruce Momjian
> * Remove old-style routines for manipulating tuples > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00851.php
2008-03-25Add to TODO:Bruce Momjian
> > * Create three versions of libpgport to simplify client code > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00154.php >
2008-03-25Add to TODO:Bruce Momjian
> > * Fix regular expression bug when using complex back-references > > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00000.php
2008-03-24Add to TODO:Bruce Momjian
> > * Allow xml arrays to be cast to other data types > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00981.php > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00231.php > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00471.php >
2008-03-24Add to TODO:Bruce Momjian
> > * Research reducing deTOASTing in more places > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00895.php
2008-03-24Add a new ereport auxiliary function errdetail_log(), which works the same asTom Lane
errdetail except the string goes only to the server log, replacing the normal errdetail there. This provides a reasonably clean way of dealing with error details that are too security-sensitive or too bulky to send to the client. This commit just adds the infrastructure --- actual uses to follow.
2008-03-24Add URL for:Bruce Momjian
* SMP scalability improvements > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00206.php
2008-03-24Add URL to:Bruce Momjian
* SMP scalability improvements > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00361.php
2008-03-24Add to TODO:Bruce Momjian
> > * SMP scalability improvements > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00439.php
2008-03-24Add URL:Bruce Momjian
* Allow statistics last vacuum/analyze execution times to be displayed without requiring stats_row_level to be enabled > > http://archives.postgresql.org/pgsql-docs/2007-04/msg00028.php >
2008-03-24Add to TODO:Bruce Momjian
> * Improve reporting of UNION type mismatches > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00944.php > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00597.php
2008-03-24Update wording:Bruce Momjian
< o Allow pre/data/post files when dumping a single object, for < performance reasons > o Allow pre/data/post files when schema and data are dumped > separately, for performance reasons
2008-03-23Update text:Bruce Momjian
< o Support pgxs > o Support pgxs when using MSVC
2008-03-23Add:Bruce Momjian
> http://archives.postgresql.org/pgsql-patches/2008-02/msg00176.php
2008-03-23Re-add:Bruce Momjian
> > * Avoid tuple some tuple copying in sort routines > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php
2008-03-23Add:Bruce Momjian
> > * Sort large UPDATE/DELETEs so it is done in heap order > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01119.php
2008-03-23Add URL for:Bruce Momjian
* Do async I/O for faster random read-ahead of data Async I/O allows multiple I/O requests to be sent to the disk with results coming back asynchronously. > http://archives.postgresql.org/pgsql-patches/2008-01/msg00170.php
2008-03-23Done:Bruce Momjian
< < * Avoid tuple some tuple copying in sort routines < < http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php
2008-03-23Add to pg_dump TODO:Bruce Momjian
> o Allow pre/data/post files when dumping a single object, for > performance reasons > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00205.php >
2008-03-23Create a function quote_nullable(), which works the same as quote_literal()Tom Lane
except that it returns the string 'NULL', rather than a SQL null, when called with a null argument. This is often a much more useful behavior for constructing dynamic queries. Add more discussion to the documentation about how to use these functions. Brendan Jurd
generated by cgit v1.2.3 (git 2.46.0) at 2025-12-07 02:02:03 +0000