[COMMITTERS] pginstaller - pginst: Forgot to remove this file earlier

2007-04-20 Thread User Mha
Log Message:
---
Forgot to remove this file earlier

Removed Files:
-
pginst/lang/en:
Makefile

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/lang/en/Makefile)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pginstaller - pginst: Security: Prep for 8.0.13

2007-04-20 Thread User Dpage
Log Message:
---
Security: Prep for 8.0.13

Tags:

REL8_0_STABLE

Modified Files:
--
pginst/package:
README.TXT (r1.1.2.12 -> r1.1.2.13)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.1.2.12&r2=1.1.2.13)
upgrade.bat (r1.1.2.13 -> r1.1.2.14)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/upgrade.bat.diff?r1=1.1.2.13&r2=1.1.2.14)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] pginstaller - pginst: Security: Prep for 8.1.9

2007-04-20 Thread User Dpage
Log Message:
---
Security: Prep for 8.1.9

Tags:

REL8_1_STABLE

Modified Files:
--
pginst/package:
README.TXT (r1.1.4.11 -> r1.1.4.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.1.4.11&r2=1.1.4.12)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pginstaller - pginst: Security: Prep for 8.2.4

2007-04-20 Thread User Dpage
Log Message:
---
Security: Prep for 8.2.4

Tags:

REL8_2_STABLE

Modified Files:
--
pginst/package:
README.TXT (r1.4.2.3 -> r1.4.2.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.4.2.3&r2=1.4.2.4)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] pginstaller - pginst: Include the DTC enlist DLLs for psqlODBC

2007-04-20 Thread User Dpage
Log Message:
---
Include the DTC enlist DLLs for psqlODBC

Tags:

REL8_2_STABLE

Modified Files:
--
pginst/wxs:
pginst.wxs (r1.182.2.2 -> r1.182.2.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.182.2.2&r2=1.182.2.3)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[COMMITTERS] pginstaller - pginst: Include the DTC enlist DLLs for psqlODBC

2007-04-20 Thread User Dpage
Log Message:
---
Include the DTC enlist DLLs for psqlODBC

Modified Files:
--
pginst/wxs:
pginst.wxs (r1.195 -> r1.196)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.195&r2=1.196)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] pginstaller - pginst: Update JDBC driver

2007-04-20 Thread User Dpage
Log Message:
---
Update JDBC driver

Modified Files:
--
pginst/wxs:
pginst.wxs (r1.196 -> r1.197)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.196&r2=1.197)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] pginstaller - pginst: Update JDBC driver

2007-04-20 Thread User Dpage
Log Message:
---
Update JDBC driver

Tags:

REL8_2_STABLE

Modified Files:
--
pginst/wxs:
pginst.wxs (r1.182.2.3 -> r1.182.2.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.182.2.3&r2=1.182.2.4)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Remove duplicate text, per Magnus.

2007-04-20 Thread Bruce Momjian
Log Message:
---
Remove duplicate text, per Magnus.

Modified Files:
--
pgsql/doc:
FAQ (r1.424 -> r1.425)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.424&r2=1.425)
pgsql/doc/src/FAQ:
FAQ.html (r1.380 -> r1.381)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff?r1=1.380&r2=1.381)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: Add mention of checking behavior of HISTORY.html to

2007-04-20 Thread Bruce Momjian
Log Message:
---
Add mention of checking  behavior of HISTORY.html to release
checklist.

Modified Files:
--
pgsql/src/tools:
RELEASE_CHANGES (r1.72 -> r1.73)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/RELEASE_CHANGES.diff?r1=1.72&r2=1.73)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[COMMITTERS] python - pkg: Bump version to 0.2.

2007-04-20 Thread James William Pye
Log Message:
---
Bump version to 0.2.

Modified Files:
--
pkg:
setup.py (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pkg/setup.py.diff?r1=1.4&r2=1.5)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] python - pkg: Use HEAD branch for HEAD.

2007-04-20 Thread James William Pye
Log Message:
---
Use HEAD branch for HEAD.

Modified Files:
--
pkg:
configure (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pkg/configure.diff?r1=1.1&r2=1.2)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] pgsql: Add script major_release_split to simplify creating release notes

2007-04-20 Thread Bruce Momjian
Log Message:
---
Add script major_release_split to simplify creating release notes for
multiple releases.

Added Files:
---
pgsql/src/tools:
major_release_split (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/major_release_split?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql: Add comment on why deadlock detection error messages only prints

2007-04-20 Thread Bruce Momjian
Log Message:
---
Add comment on why deadlock detection error messages only prints numbers.

Modified Files:
--
pgsql/src/backend/storage/lmgr:
deadlock.c (r1.46 -> r1.47)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/deadlock.c.diff?r1=1.46&r2=1.47)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] pgsql: Documentation for UUID type

2007-04-20 Thread Peter Eisentraut
Log Message:
---
Documentation for UUID type

Modified Files:
--
pgsql/doc/src/sgml:
datatype.sgml (r1.196 -> r1.197)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml.diff?r1=1.196&r2=1.197)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] psqlodbc - psqlodbc: Update the installer for WiX3.

2007-04-20 Thread User H-saito
Log Message:
---
Update the installer for WiX3.
He has forgotten then. sorry..

Modified Files:
--
psqlodbc:
Makefile.am (r1.41 -> r1.42)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/Makefile.am.diff?r1=1.41&r2=1.42)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[COMMITTERS] pgsql: Tweak set_rel_width() to avoid redundant executions of

2007-04-20 Thread Tom Lane
Log Message:
---
Tweak set_rel_width() to avoid redundant executions of getrelid().
In very large queries this accounts for a noticeable fraction of
planning time.  Per an example from Greg Stark.

Modified Files:
--
pgsql/src/backend/optimizer/path:
costsize.c (r1.179 -> r1.180)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c.diff?r1=1.179&r2=1.180)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: Adjust pgstat_initstats() to avoid repeated searches of the

2007-04-20 Thread Tom Lane
Log Message:
---
Adjust pgstat_initstats() to avoid repeated searches of the TabStat arrays
when a relation is opened multiple times in the same transaction.  This is
particularly useful for system catalogs, which we may heap_open or index_open
many times in a transaction, and it doesn't really cost anything extra even
if the rel is touched but once.  Motivated by study of an example from Greg
Stark, in which pgstat_initstats() accounted for an unreasonably large
fraction of the runtime.

Modified Files:
--
pgsql/src/backend/postmaster:
pgstat.c (r1.152 -> r1.153)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.152&r2=1.153)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] pgsql: Improve the way in which CatalogCacheComputeHashValue combines

2007-04-20 Thread Tom Lane
Log Message:
---
Improve the way in which CatalogCacheComputeHashValue combines multiple key
values: don't throw away perfectly good hash bits, and increase the shift
distances so as to provide more separation in the common case where some of
the key values are small integers (and so their hashes are too, because
hashfunc.c doesn't try all that hard).  This reduces the runtime of
SearchCatCache by a factor of 4 in an example provided by Greg Stark,
in which the planner spends a whole lot of time searching the two-key
STATRELATT cache.  It seems unlikely to hurt in other cases, but maybe
we could do even better?

Modified Files:
--
pgsql/src/backend/utils/cache:
catcache.c (r1.136 -> r1.137)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/catcache.c.diff?r1=1.136&r2=1.137)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: Tweak make_inh_translation_lists() to check the common case

2007-04-20 Thread Tom Lane
Log Message:
---
Tweak make_inh_translation_lists() to check the common case wherein parent and
child attnums are the same, before it grovels through each and every child
column looking for a name match.  Saves some time in large inheritance trees,
per example from Greg.

Modified Files:
--
pgsql/src/backend/optimizer/prep:
prepunion.c (r1.140 -> r1.141)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepunion.c.diff?r1=1.140&r2=1.141)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] pgsql: Avoid useless work during set_plain_rel_pathlist() when the

2007-04-20 Thread Tom Lane
Log Message:
---
Avoid useless work during set_plain_rel_pathlist() when the relation
will be excluded by constraint exclusion anyway.  Greg Stark

Modified Files:
--
pgsql/src/backend/optimizer/path:
allpaths.c (r1.161 -> r1.162)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/allpaths.c.diff?r1=1.161&r2=1.162)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate