]> granicus.if.org Git - postgresql/log
postgresql
16 years agoCatch all errors in for and while loops in makefiles. Don't ignore any
Peter Eisentraut [Tue, 18 Mar 2008 16:24:50 +0000 (16:24 +0000)]
Catch all errors in for and while loops in makefiles.  Don't ignore any
errors in any commands, including in various clean targets that have so far
been handled inconsistently.  make -i is available to ignore all errors in
a consistent and official way.

16 years agocvsweb lives on anoncvs.postgresql.org these days.
Magnus Hagander [Tue, 18 Mar 2008 16:05:07 +0000 (16:05 +0000)]
cvsweb lives on anoncvs.postgresql.org these days.

16 years agoWiki page about cvs now lives in the main wiki, the one
Magnus Hagander [Tue, 18 Mar 2008 16:02:27 +0000 (16:02 +0000)]
Wiki page about cvs now lives in the main wiki, the one
on developer.postgresql.org is going away.

16 years agoAdd TODO URLs for:
Bruce Momjian [Tue, 18 Mar 2008 15:30:59 +0000 (15:30 +0000)]
Add TODO URLs for:

        o Allow UPDATE tab SET ROW (col, ...) = (SELECT...)

>    http://archives.postgresql.org/pgsql-patches/2007-04/msg00315.php
>    http://archives.postgresql.org/pgsql-patches/2008-03/msg00237.php

16 years agoMove elog(DEBUG4) call outside the locked area, per suggestion from Tom Lane.
Alvaro Herrera [Tue, 18 Mar 2008 12:36:43 +0000 (12:36 +0000)]
Move elog(DEBUG4) call outside the locked area, per suggestion from Tom Lane.

16 years agoAdd URLs for :
Bruce Momjian [Tue, 18 Mar 2008 03:59:45 +0000 (03:59 +0000)]
Add URLs for :

* 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-general/2007-12/msg00683.php
>   http://archives.postgresql.org/pgsql-hackers/2007-12/msg00497.php
<

16 years agoAdvance multiple array keys rightmost-first instead of leftmost-first
Tom Lane [Tue, 18 Mar 2008 03:54:52 +0000 (03:54 +0000)]
Advance multiple array keys rightmost-first instead of leftmost-first
during a bitmap index scan.  This cannot affect the query results
(since we're just dumping the TIDs into a bitmap) but it might offer
some advantage in locality of access to the index.  Per Greg Stark.

16 years agoAdd TODO:
Bruce Momjian [Tue, 18 Mar 2008 02:37:05 +0000 (02:37 +0000)]
Add TODO:

>  o Recreate pg_xlog/archive_status/ if it doesn't exist after
>    restoring from a PITR backup
>
>    http://archives.postgresql.org/pgsql-hackers/2007-12/msg00487.php

16 years agoFix our printf implementation to follow spec: if a star parameter
Tom Lane [Tue, 18 Mar 2008 01:49:44 +0000 (01:49 +0000)]
Fix our printf implementation to follow spec: if a star parameter
value for a precision is negative, act as though precision weren't
specified at all, that is the whole .* part of the format spec should
be ignored.  Our previous coding took it as .0 which is certainly
wrong.  Per report from Kris Jurka and local testing.

Possibly this should be back-patched, but it would be good to get
some more testing first; in any case there are no known cases where
there's really a problem on the backend side.

16 years agoAdd to TODO:
Bruce Momjian [Tue, 18 Mar 2008 00:43:01 +0000 (00:43 +0000)]
Add to TODO:

>
> * Consider Cartesian joins when both relations are needed to form an
>   indexscan qualification for a third relation
>
>   http://archives.postgresql.org/pgsql-performance/2007-12/msg00090.php

16 years agoAdd URL for:
Bruce Momjian [Tue, 18 Mar 2008 00:23:41 +0000 (00:23 +0000)]
Add URL for:

        o Allow COPY to report error lines and continue

          This requires the use of a savepoint before each COPY line is
          processed, with ROLLBACK on COPY failure.
>    http://archives.postgresql.org/pgsql-hackers/2007-12/msg00572.php

16 years agoAdd to TODO:
Bruce Momjian [Mon, 17 Mar 2008 23:56:30 +0000 (23:56 +0000)]
Add to TODO:

>
> * Allow SSL key file permission checks to be optionally disabled when
>   sharing SSL keys with other applications
>
>   http://archives.postgresql.org/pgsql-bugs/2007-12/msg00069.php

16 years agoAdd:
Bruce Momjian [Mon, 17 Mar 2008 23:49:33 +0000 (23:49 +0000)]
Add:

>
> * Reduce BIT data type overhead using short varlena headers
>
>   http://archives.postgresql.org/pgsql-general/2007-12/msg00273.php

16 years agoAdd to TODO:
Bruce Momjian [Mon, 17 Mar 2008 23:32:21 +0000 (23:32 +0000)]
Add to TODO:

> * Reduce file system activity overhead of statistics file pgstat.stat
>
>   http://archives.postgresql.org/pgsql-general/2007-12/msg00106.php
>

16 years agoAdd to TODO:
Bruce Momjian [Mon, 17 Mar 2008 22:59:01 +0000 (22:59 +0000)]
Add to TODO:

> * Consider if CommandCounterIncrement() can avoid its
>   AcceptInvalidationMessages() call
>
>   http://archives.postgresql.org/pgsql-committers/2007-11/msg00585.php

16 years agoAdd URL for:
Bruce Momjian [Mon, 17 Mar 2008 22:54:23 +0000 (22:54 +0000)]
Add URL for:

* Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT

>   http://archives.postgresql.org/pgsql-hackers/2007-11/msg01334.php

16 years agoAdd:
Bruce Momjian [Mon, 17 Mar 2008 22:53:02 +0000 (22:53 +0000)]
Add:

>
>  o Remove pre-7.3 pg_dump code that assumes pg_depend does not exit

16 years agoAdd URL for:
Bruce Momjian [Mon, 17 Mar 2008 22:45:20 +0000 (22:45 +0000)]
Add URL for:

* Improve text search error messages

>   http://archives.postgresql.org/pgsql-hackers/2007-11/msg01146.php

16 years agoAdded to TODO:
Bruce Momjian [Mon, 17 Mar 2008 22:34:23 +0000 (22:34 +0000)]
Added to TODO:

> * Improve text search error messages
>
>   http://archives.postgresql.org/pgsql-hackers/2007-10/msg00966.php
>
>
> * Fix /contrib/ltree operator
>
>   http://archives.postgresql.org/pgsql-bugs/2007-11/msg00044.php

16 years agoAdd TODO:
Bruce Momjian [Mon, 17 Mar 2008 21:49:11 +0000 (21:49 +0000)]
Add TODO:

>
>  o Fix server restart problem when the server was shutdown during
>    a PITR backup
>
>    http://archives.postgresql.org/pgsql-hackers/2007-11/msg00800.php
>

16 years agoAdjust TODO spacing.
Bruce Momjian [Mon, 17 Mar 2008 21:45:14 +0000 (21:45 +0000)]
Adjust TODO spacing.

16 years agoAdd TODO URL for:
Bruce Momjian [Mon, 17 Mar 2008 21:09:30 +0000 (21:09 +0000)]
Add TODO URL for:

* Consider increasing the number of default statistics target, and
  reduce statistics target overhead

>   http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php

16 years agoEnable probes to work with Mac OS X Leopard and other OSes that will
Peter Eisentraut [Mon, 17 Mar 2008 19:44:41 +0000 (19:44 +0000)]
Enable probes to work with Mac OS X Leopard and other OSes that will
support DTrace in the future.

Switch from using DTRACE_PROBEn macros to the dynamically generated macros.
Use "dtrace -h" to create a header file that contains the dynamically
generated macros to be used in the source code instead of the DTRACE_PROBEn
macros.  A dummy header file is generated for builds without DTrace support.

Author: Robert Lor <Robert.Lor@sun.com>

16 years agoWe need to rebuild objfiles.txt when one of the subdirectories' objfiles.txt
Peter Eisentraut [Mon, 17 Mar 2008 18:24:56 +0000 (18:24 +0000)]
We need to rebuild objfiles.txt when one of the subdirectories' objfiles.txt
changed in case a new file got added.

16 years agoAdd:
Bruce Momjian [Mon, 17 Mar 2008 18:22:44 +0000 (18:22 +0000)]
Add:
>
>  o Allow Kerberos to disable stripping of realms so we can
>    check the username@realm against multiple realms
>
>    http://archives.postgresql.org/pgsql-hackers/2007-11/msg00009.php

16 years agoFix postgres --describe-config for guc enums, breakage noted by Alvaro.
Magnus Hagander [Mon, 17 Mar 2008 17:45:09 +0000 (17:45 +0000)]
Fix postgres --describe-config for guc enums, breakage noted by Alvaro.

While at it, rename option lookup functions to make names clearer, per
discussion with Tom.

16 years agoRevert thinko introduced into prefix_selectivity() by my recent patch:
Tom Lane [Mon, 17 Mar 2008 17:13:54 +0000 (17:13 +0000)]
Revert thinko introduced into prefix_selectivity() by my recent patch:
make_greater_string needs the < procedure not the >= one.  Spotted by
Peter.

16 years agoMove ProcState definition into sinvaladt.c from sinvaladt.h, since it's not
Alvaro Herrera [Mon, 17 Mar 2008 11:50:27 +0000 (11:50 +0000)]
Move ProcState definition into sinvaladt.c from sinvaladt.h, since it's not
needed anywhere after my previous patch.  Noticed by Tom Lane.

Also, remove #include <signal.h> from sinval.c.

16 years agoGrab some low-hanging fruit in the new hash index build code.
Tom Lane [Mon, 17 Mar 2008 03:45:36 +0000 (03:45 +0000)]
Grab some low-hanging fruit in the new hash index build code.
oprofile shows that a nontrivial amount of time is being spent in
repeated calls to index_getprocinfo, which really only needs to be
called once.  So do that, and inline _hash_datum2hashkey to make it
work.

16 years agoFix TransactionIdIsCurrentTransactionId() to use binary search instead of
Tom Lane [Mon, 17 Mar 2008 02:18:55 +0000 (02:18 +0000)]
Fix TransactionIdIsCurrentTransactionId() to use binary search instead of
linear search when checking child-transaction XIDs.  This makes for an
important speedup in transactions that have large numbers of children,
as in a recent example from Craig Ringer.  We can also get rid of an
ugly kluge that represented lists of TransactionIds as lists of OIDs.

Heikki Linnakangas

16 years agoDone:
Bruce Momjian [Mon, 17 Mar 2008 01:46:42 +0000 (01:46 +0000)]
Done:

>  o -During index creation, pre-sort the tuples to improve build speed

16 years agoAdd a note to the CREATE INDEX reference page about the impact of
Tom Lane [Sun, 16 Mar 2008 23:57:51 +0000 (23:57 +0000)]
Add a note to the CREATE INDEX reference page about the impact of
maintenance_work_mem and effective_cache_size on index creation speed.

16 years agoWhen creating a large hash index, pre-sort the index entries by estimated
Tom Lane [Sun, 16 Mar 2008 23:15:08 +0000 (23:15 +0000)]
When creating a large hash index, pre-sort the index entries by estimated
bucket number, so as to ensure locality of access to the index during the
insertion step.  Without this, building an index significantly larger than
available RAM takes a very long time because of thrashing.  On the other
hand, sorting is just useless overhead when the index does fit in RAM.
We choose to sort when the initial index size exceeds effective_cache_size.

This is a revised version of work by Tom Raney and Shreya Bhargava.

16 years agoModify interactions between sinval.c and sinvaladt.c. The code that actually
Alvaro Herrera [Sun, 16 Mar 2008 19:47:34 +0000 (19:47 +0000)]
Modify interactions between sinval.c and sinvaladt.c.  The code that actually
deals with the queue, including locking etc, is all in sinvaladt.c.  This means
that the struct definition of the queue, and the queue pointer, are now
internal "implementation details" inside sinvaladt.c.

Per my proposal dated 25-Jun-2007 and followup discussion.

16 years agoSome cleanups of enum-guc code, per comments from Tom.
Magnus Hagander [Sun, 16 Mar 2008 16:42:44 +0000 (16:42 +0000)]
Some cleanups of enum-guc code, per comments from Tom.

16 years agoChange hash index creation so that rather than always establishing exactly
Tom Lane [Sat, 15 Mar 2008 20:46:31 +0000 (20:46 +0000)]
Change hash index creation so that rather than always establishing exactly
two buckets at the start, we create a number of buckets appropriate for the
estimated size of the table.  This avoids a lot of expensive bucket-split
actions during initial index build on an already-populated table.

This is one of the two core ideas of Tom Raney and Shreya Bhargava's patch
to reduce hash index build time.  I'm committing it separately to make it
easier for people to test the effects of this separately from the effects
of their other core idea (pre-sorting the index entries by bucket number).

16 years agoFix inappropriately-timed memory context switch in autovacuum_do_vac_analyze.
Tom Lane [Fri, 14 Mar 2008 23:49:28 +0000 (23:49 +0000)]
Fix inappropriately-timed memory context switch in autovacuum_do_vac_analyze.
This accidentally failed to fail before 8.3, because the context we were
switching back to was long-lived anyway; but it sure looks risky as can be
now.  Well spotted by Pavan Deolasee.

16 years agoFix duplicate word, per Guillaume Lelarge.
Alvaro Herrera [Fri, 14 Mar 2008 17:28:23 +0000 (17:28 +0000)]
Fix duplicate word, per Guillaume Lelarge.

16 years agoFix vacuum so that autovacuum is really not cancelled when doing an emergency
Alvaro Herrera [Fri, 14 Mar 2008 17:25:59 +0000 (17:25 +0000)]
Fix vacuum so that autovacuum is really not cancelled when doing an emergency
job (i.e. to prevent Xid wraparound problems.)  Bug reported by ITAGAKI
Takahiro in 20080314103837.63D3.52131E4D@oss.ntt.co.jp, though I didn't use his
patch.

16 years agoUpdate release notes for 8.3.1 and 8.2.7 releases.
Tom Lane [Thu, 13 Mar 2008 23:47:49 +0000 (23:47 +0000)]
Update release notes for 8.3.1 and 8.2.7 releases.

16 years agoUpdate to tzdata 2008a distribution (Chilean DST law change).
Tom Lane [Thu, 13 Mar 2008 19:21:43 +0000 (19:21 +0000)]
Update to tzdata 2008a distribution (Chilean DST law change).

16 years agoFix varstr_cmp's special case for UTF8 encoding on Windows so that strings
Tom Lane [Thu, 13 Mar 2008 18:31:56 +0000 (18:31 +0000)]
Fix varstr_cmp's special case for UTF8 encoding on Windows so that strings
that are reported as "equal" by wcscoll() are checked to see if they really
are bitwise equal, and are sorted per strcmp() if not.  We made this happen
a couple of years ago in the regular code path, but it unaccountably got
left out of the Windows/UTF8 case (probably brain fade on my part at the
time).  As in the prior set of changes, affected users may need to reindex
indexes on textual columns.

Backpatch as far as 8.2, which is the oldest release we are still supporting
on Windows.

16 years agoFix heap_page_prune's problem with failing to send cache invalidation
Tom Lane [Thu, 13 Mar 2008 18:00:32 +0000 (18:00 +0000)]
Fix heap_page_prune's problem with failing to send cache invalidation
messages if the calling transaction aborts later on.  Collapsing out line
pointer redirects is a done deal as soon as we complete the page update,
so syscache *must* be notified even if the VACUUM FULL as a whole doesn't
complete.  To fix, add some functionality to inval.c to allow the pending
inval messages to be sent immediately while heap_page_prune is still
running.  The implementation is a bit chintzy: it will only work in the
context of VACUUM FULL.  But that's all we need now, and it can always be
extended later if needed.  Per my trouble report of a week ago.

16 years agoAdd URL for:
Bruce Momjian [Thu, 13 Mar 2008 01:56:46 +0000 (01:56 +0000)]
Add URL for:

* 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-performance/2007-09/msg00255.php

16 years agoFix pg_plan_queries() to restore the previous setting of ActiveSnapshot
Tom Lane [Wed, 12 Mar 2008 23:58:27 +0000 (23:58 +0000)]
Fix pg_plan_queries() to restore the previous setting of ActiveSnapshot
(probably NULL) before exiting.  Up to now it's just left the variable as it
set it, which means that after we're done processing the current client
message, ActiveSnapshot is probably pointing at garbage (because this function
is typically run in MessageContext which will get reset).  There doesn't seem
to have been any code path in which that mattered before 8.3, but now the
plancache module might try to use the stale value if the next client message
is a Bind for a prepared statement that is in need of replanning.  Per report
from Alex Hunsaker.

16 years agoAdd psql TODO:
Bruce Momjian [Wed, 12 Mar 2008 20:50:22 +0000 (20:50 +0000)]
Add psql TODO:

< * Include the symbolic SQLSTATE name in verbose error reports
<
<   http://archives.postgresql.org/pgsql-general/2007-09/msg00438.php

16 years agoAdd to TODO:
Bruce Momjian [Wed, 12 Mar 2008 20:19:46 +0000 (20:19 +0000)]
Add to TODO:

> * Expire published xmin for read-only and idle transactions
>
>   http://archives.postgresql.org/pgsql-hackers/2007-09/msg00343.php

16 years agoFix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing
Tom Lane [Wed, 12 Mar 2008 20:11:46 +0000 (20:11 +0000)]
Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponing
pg_listener modifications commanded by LISTEN and UNLISTEN until the end
of the current transaction.  This allows us to hold the ExclusiveLock on
pg_listener until after commit, with no greater risk of deadlock than there
was before.  Aside from fixing the race condition, this gets rid of a
truly ugly kludge that was there before, namely having to ignore
HeapTupleBeingUpdated failures during NOTIFY.  There is a small potential
incompatibility, which is that if a transaction issues LISTEN or UNLISTEN
and then looks into pg_listener before committing, it won't see any resulting
row insertion or deletion, where before it would have.  It seems unlikely
that anyone would be depending on that, though.

This patch also disallows LISTEN and UNLISTEN inside a prepared transaction.
That case had some pretty undesirable properties already, such as possibly
allowing pg_listener entries to be made for PIDs no longer present, so
disallowing it seems like a better idea than trying to maintain the behavior.

16 years agoAdd:
Bruce Momjian [Wed, 12 Mar 2008 19:41:23 +0000 (19:41 +0000)]
Add:

>
> * Consider a special data type for regular expressions
>
>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php

16 years agoBack out text search change to TODO.
Bruce Momjian [Wed, 12 Mar 2008 19:40:01 +0000 (19:40 +0000)]
Back out text search change to TODO.

16 years agoUpdate TODO:
Bruce Momjian [Wed, 12 Mar 2008 19:32:07 +0000 (19:32 +0000)]
Update TODO:

* Add array_accum() and array_to_set() functions for arrays

  The standards specify array_agg() and UNNEST.
  http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php

16 years agoAdd URL for:
Bruce Momjian [Wed, 12 Mar 2008 19:30:59 +0000 (19:30 +0000)]
Add URL for:

* Consider a simplified API for full text searches

>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php

16 years agoAdd for Win32 TODO:
Bruce Momjian [Wed, 12 Mar 2008 19:28:03 +0000 (19:28 +0000)]
Add for Win32 TODO:

>
>  o Convert MSVC build system to remove most batch files
>
>    http://archives.postgresql.org/pgsql-hackers/2007-08/msg00961.php

16 years agoAdd URL for:
Bruce Momjian [Wed, 12 Mar 2008 19:15:25 +0000 (19:15 +0000)]
Add URL for:

* Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY

>   http://archives.postgresql.org/pgsql-performance/2007-08/msg00289.php

16 years agoAdd for Win32 TODO:
Bruce Momjian [Wed, 12 Mar 2008 18:33:54 +0000 (18:33 +0000)]
Add for Win32 TODO:

>  o Diagnose problem where shared memory can sometimes not be
>    attached by postmaster children
>
>    http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php
>

16 years agoAdd to TODO:
Bruce Momjian [Wed, 12 Mar 2008 18:32:29 +0000 (18:32 +0000)]
Add to TODO:

>
> * Remove use of MAKE_PTR and MAKE_OFFSET macros
>
>   http://archives.postgresql.org/pgsql-general/2007-08/msg01510.php

16 years agoAdd to TODO:
Bruce Momjian [Wed, 12 Mar 2008 15:14:50 +0000 (15:14 +0000)]
Add to TODO:

>
> * Add array_accum() and array_to_set() functions for arrays
>
>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php

16 years agoAdd a comment explaining one of the ways that pgbench fails to fully
Tom Lane [Wed, 12 Mar 2008 02:18:33 +0000 (02:18 +0000)]
Add a comment explaining one of the ways that pgbench fails to fully
comply with TPC-B.  Per Itagaki Takahiro and discussion of bug#3681.

16 years agoAdd URL for:
Bruce Momjian [Wed, 12 Mar 2008 01:48:08 +0000 (01:48 +0000)]
Add URL for:

* Improve speed with indexes

  For large table adjustments during VACUUM FULL, it is faster to cluster
  or reindex rather than update the index.  Also, index updates can bloat
  the index.

>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.php

16 years agoAdd:
Bruce Momjian [Wed, 12 Mar 2008 01:40:09 +0000 (01:40 +0000)]
Add:

>
> * Allow domains to be cast
>
>   http://archives.postgresql.org/pgsql-hackers/2003-06/msg01206.php
>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg00289.php

16 years agoAdd:
Bruce Momjian [Wed, 12 Mar 2008 01:35:00 +0000 (01:35 +0000)]
Add:

>
> * Consider simplifying how memory context resets handle child contexts
>
>   http://archives.postgresql.org/pgsql-patches/2007-08/msg00067.php

16 years agoAdd URL for:
Bruce Momjian [Wed, 12 Mar 2008 01:21:25 +0000 (01:21 +0000)]
Add URL for:

>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg00082.php

16 years agoAdd URL for:
Bruce Momjian [Wed, 12 Mar 2008 01:08:32 +0000 (01:08 +0000)]
Add URL for:

* Consider increasing NUM_CLOG_BUFFERS

>   http://archives.postgresql.org/pgsql-performance/2007-08/msg00024.php

16 years agoAdd URL for:
Bruce Momjian [Wed, 12 Mar 2008 01:03:04 +0000 (01:03 +0000)]
Add URL for:

* Consider increasing NUM_CLOG_BUFFERS
>
>   http://archives.postgresql.org/pgsql-hackers/2007-08/msg00030.php
>

16 years agoPrevent psql \copy from accepting multiple string parameters, e.g.
Bruce Momjian [Tue, 11 Mar 2008 23:30:56 +0000 (23:30 +0000)]
Prevent psql \copy from accepting multiple string parameters, e.g.

test=> \copy billing_data from ../BillingSamplePricerFile.csv with csv
   header quote as '"' null as 'abc' null as '123'
\copy: parse error at "null"

Per report from Stephen Frost

16 years agoUpdate TODO:
Bruce Momjian [Tue, 11 Mar 2008 23:17:05 +0000 (23:17 +0000)]
Update TODO:

        o Allow COPY in CSV mode to control whether a quoted zero-length
          string is treated as NULL

          Currently this is always treated as a zero-length string,
          which generates an error when loading into an integer column

16 years agoadd to TODO COPY:
Bruce Momjian [Tue, 11 Mar 2008 22:47:28 +0000 (22:47 +0000)]
add to TODO COPY:

>
>  o Allow COPY in CSV mode to control whether "" is treated as NULL
>
>    http://archives.postgresql.org/pgsql-hackers/2007-07/msg00905.php

16 years agoAdd to pl/pgsql:
Bruce Momjian [Tue, 11 Mar 2008 22:31:02 +0000 (22:31 +0000)]
Add to pl/pgsql:

>
>  o Improve logic of determining if an identifier is a a
>    variable or column name
>
>    http://archives.postgresql.org/pgsql-hackers/2007-07/msg00436.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 21:25:02 +0000 (21:25 +0000)]
Add:

>
> * Add automated check for invalid C++ source code constructs
>
>   http://archives.postgresql.org/pgsql-patches/2007-07/msg00056.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 21:13:13 +0000 (21:13 +0000)]
Add:

> * Research use of signals and sleep wake ups
>
>   http://archives.postgresql.org/pgsql-hackers/2007-07/msg00003.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 21:06:10 +0000 (21:06 +0000)]
Add:

* Test to see if calling PreallocXlogFiles() from the background writer
  will help with WAL segment creation latency

  http://archives.postgresql.org/pgsql-patches/2007-06/msg00340.php

16 years ago< * Consider adding buffers the BGW finds reusable to the free list
Bruce Momjian [Tue, 11 Mar 2008 20:46:20 +0000 (20:46 +0000)]
< * Consider adding buffers the BGW finds reusable to the free list
> * Consider adding buffers the background writer finds reusable to the
>   free list
>
> * Consider wither increasing BM_MAX_USAGE_COUNT improves performance
>
>   http://archives.postgresql.org/pgsql-hackers/2007-06/msg01007.php

16 years agoAdd URL for:
Bruce Momjian [Tue, 11 Mar 2008 20:28:13 +0000 (20:28 +0000)]
Add URL for:

* Reduce storage space for small NUMERICs

>   http://archives.postgresql.org/pgsql-hackers/2007-06/msg00715.php

16 years agoMake TransactionIdIsInProgress check transam.c's single-item XID status cache
Tom Lane [Tue, 11 Mar 2008 20:20:35 +0000 (20:20 +0000)]
Make TransactionIdIsInProgress check transam.c's single-item XID status cache
before it goes groveling through the ProcArray.  In situations where the same
recently-committed transaction ID is checked repeatedly by tqual.c, this saves
a lot of shared-memory searches.  And it's cheap enough that it shouldn't
hurt noticeably when it doesn't help.
Concept and patch by Simon, some minor tweaking and comment-cleanup by Tom.

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 20:16:40 +0000 (20:16 +0000)]
Add:

>  o Consider normalizing fractions in postgresql.conf, perhaps
>    using '%'
>
>    http://archives.postgresql.org/pgsql-hackers/2007-06/msg00550.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 20:04:56 +0000 (20:04 +0000)]
Add:

> * Consider sorting writes during checkpoint
>
>   http://archives.postgresql.org/pgsql-hackers/2007-06/msg00541.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 19:48:17 +0000 (19:48 +0000)]
Add:

>
> * Prefix command-line utilities like createuser with 'pg_'
>
>   http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 19:44:39 +0000 (19:44 +0000)]
Add:

>
> * Change memory allocation for multi-byte functions so memory is
>   allocated inside conversion functions
>
>   Currently we preallocate memory based on worst-case usage.

16 years agoAdd another URL for:
Bruce Momjian [Tue, 11 Mar 2008 19:34:12 +0000 (19:34 +0000)]
Add another URL for:

* Consider increasing the number of default statistics target, and
  reduce statistics target overhead

  Also consider having a larger statistics target for indexed columns
  and expression indexes
<
>   http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php

16 years agoAdd URL for:
Bruce Momjian [Tue, 11 Mar 2008 19:32:03 +0000 (19:32 +0000)]
Add URL for:

* Consider increasing the number of default statistics target, and
  reduce statistics target overhead

  Also consider having a larger statistics target for indexed columns
  and expression indexes
>   http://archives.postgresql.org/pgsql-general/2007-05/msg01228.php
>

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 18:30:50 +0000 (18:30 +0000)]
Add:

>
> * Consider increasing the number of default statistics target, and
>   reduce statistics target overhead
>
>   Also consider having a larger statistics target for indexed columns
>   and expression indexes

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 18:14:57 +0000 (18:14 +0000)]
Add:

>
> * Consider using a hash for joining to a large IN (VALUES ...) list
>
>   http://archives.postgresql.org/pgsql-hackers/2007-05/msg00450.php

16 years agoAdd for VACUUM:
Bruce Momjian [Tue, 11 Mar 2008 18:05:10 +0000 (18:05 +0000)]
Add for VACUUM:

>
> * Consider a more compact data representation for dead tuples
>
>   http://archives.postgresql.org/pgsql-patches/2007-05/msg00143.php

16 years agoAdd URL for:
Bruce Momjian [Tue, 11 Mar 2008 18:01:04 +0000 (18:01 +0000)]
Add URL for:

* Fix problem when multiple subtransactions of the same outer transaction
  hold different types of locks, and one subtransaction aborts

>   http://archives.postgresql.org/pgsql-hackers/2007-05/msg00773.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 17:42:13 +0000 (17:42 +0000)]
Add:

>
> * Add temporal versions of generate_series()
>
>   http://archives.postgresql.org/pgsql-hackers/2007-04/msg01180.php

16 years agoAdd for pl/pgsql:
Bruce Momjian [Tue, 11 Mar 2008 17:20:47 +0000 (17:20 +0000)]
Add for pl/pgsql:

o Review handling of MOVE and FETCH

http://archives.postgresql.org/pgsql-patches/2007-04/msg00527.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 17:02:33 +0000 (17:02 +0000)]
Add:

>  o Prevent pg_dump/pg_restore from being affected by
>    statement_timeout
>
>    Using psql to restore a pg_dump dump is also affected.

16 years agoAdd to documentation:
Bruce Momjian [Tue, 11 Mar 2008 16:59:00 +0000 (16:59 +0000)]
Add to documentation:

+         Setting <varname>statement_timeout</> in
+         <filename>postgresql.conf</> is not recommended because it
+         affects all sessions.

Backpatch to 8.3.X.

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 15:52:02 +0000 (15:52 +0000)]
Add:

> * Allow statistics last vacuum/analyze execution times to be displayed
>   without requiring stats_row_level to be enabled

16 years agoBack out doc addition that statement_timeout affects autovacuum.
Bruce Momjian [Tue, 11 Mar 2008 15:49:46 +0000 (15:49 +0000)]
Back out doc addition that statement_timeout affects autovacuum.

16 years agoRemove item, per Alvaro:
Bruce Momjian [Tue, 11 Mar 2008 15:48:50 +0000 (15:48 +0000)]
Remove item, per Alvaro:

<
<  o Set up autovacuum to ignore statement_timeout set in
<    postgresql.conf
<
<    http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 15:45:05 +0000 (15:45 +0000)]
Add:

>
> * Consider adding buffers the BGW finds reusable to the free list
>
>   http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php
>
> * Automatically tune bgwriter_delay based on activity rather then using a
>   fixed interval
>
>   http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php

16 years agoDocument that statement_timeout is not recommended in postgresql.conf
Bruce Momjian [Tue, 11 Mar 2008 15:39:23 +0000 (15:39 +0000)]
Document that statement_timeout is not recommended in postgresql.conf
because it affects all sessions, including autovacuum.

16 years agoAdd:
Bruce Momjian [Tue, 11 Mar 2008 15:38:54 +0000 (15:38 +0000)]
Add:

>
>  o Set up autovacuum to ignore statement_timeout set in
>    postgresql.conf
>
>    http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php

16 years agoAdd URL for:
Bruce Momjian [Tue, 11 Mar 2008 14:56:52 +0000 (14:56 +0000)]
Add URL for:

* Optimize referential integrity checks

>   http://archives.postgresql.org/pgsql-hackers/2007-04/msg00744.php

16 years agoAdd URL for:
Bruce Momjian [Tue, 11 Mar 2008 14:25:51 +0000 (14:25 +0000)]
Add URL for:

* Allow administrators to safely terminate individual sessions either
  via an SQL function or SIGTERM

>   http://archives.postgresql.org/pgsql-hackers/2007-04/msg00218.php

16 years agoUse -fwrapv in CFLAGS if we are using a version of gcc that accepts this flag.
Tom Lane [Mon, 10 Mar 2008 21:50:16 +0000 (21:50 +0000)]
Use -fwrapv in CFLAGS if we are using a version of gcc that accepts this flag.
This prevents compiler optimizations that assume overflow won't occur, which
breaks numerous overflow tests that we need to have working.  It is known
that gcc 4.3 causes problems and possible that 4.1 does.  Per my proposal
of some time ago and a recent report from Kris Jurka.

Backpatch as far as 8.0, which is as far as the patch conveniently goes.
7.x was pretty short of overflow tests anyway, so it may not matter there,
even assuming that anyone cares whether 7.x builds on recent gcc.

16 years agoProvide a build-time option to store large relations as single files, rather
Tom Lane [Mon, 10 Mar 2008 20:06:27 +0000 (20:06 +0000)]
Provide a build-time option to store large relations as single files, rather
than dividing them into 1GB segments as has been our longtime practice.  This
requires working support for large files in the operating system; at least for
the time being, it won't be the default.

Zdenek Kotala

16 years agoAdd:
Bruce Momjian [Mon, 10 Mar 2008 14:16:37 +0000 (14:16 +0000)]
Add:

>
> * Consider increasing the minimum allowed number of shared buffers
>
>   http://archives.postgresql.org/pgsql-bugs/2008-02/msg00157.php
>

16 years agoBump catversion from guc enum patch, which I forgot. Sorry!
Magnus Hagander [Mon, 10 Mar 2008 13:53:35 +0000 (13:53 +0000)]
Bump catversion from guc enum patch, which I forgot. Sorry!