summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
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
2008-03-23Add to Win3 TODO:Bruce Momjian
> > o Fix MSVC NLS support, like for to_char() > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00485.php > http://archives.postgresql.org/pgsql-patches/2008-02/msg00038.php
2008-03-23Add to TODO:Bruce Momjian
> > * Improve WAL concurrency by increasing lock granularity > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00556.php >
2008-03-22Add to Win32 TODOBruce Momjian
> > o Support pgxs
2008-03-22Add to TODO:Bruce Momjian
> > * Avoid tuple some tuple copying in sort routines > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php
2008-03-22Add URL for TODO:Bruce Momjian
o Add checks to prevent a CREATE RULE views on inherited tables > http://archives.postgresql.org/pgsql-general/2008-03/msg00077.php
2008-03-22Add to TODO:Bruce Momjian
> > o Add checks to prevent a CREATE RULE views on inherited tables > > http://archives.postgresql.org/pgsql-general/2008-02/msg01420.php
2008-03-22Add server side lo_import(filename, oid) function.Tatsuo Ishii
2008-03-22Add URL for:Bruce Momjian
* Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00387.php
2008-03-22Add URL for:Bruce Momjian
* Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00248.php
2008-03-22Add TODO:Bruce Momjian
> > * Improve performance of shared invalidation queue for multiple CPUs > > http://archives.postgresql.org/pgsql-performance/2008-01/msg00023.php
2008-03-22Add URLs for:Bruce Momjian
* Simplify ability to create partitioned tables This would allow creation of partitioned tables without requiring creation of triggers or rules for INSERT/UPDATE/DELETE, and constraints for rapid partition selection. Options could include range and hash partition selection. > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00028.php > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00413.php
2008-03-21Add:Bruce Momjian
> > * Convert single quotes to apostrophes in the PDF documentation > > http://archives.postgresql.org/pgsql-docs/2007-12/msg00059.php >
generated by cgit v1.2.3 (git 2.46.0) at 2025-09-30 03:08:02 +0000