[COMMITTERS] pgbouncer - pgbouncer: add server vars to SHOW FDS, relax result parsing

2007-08-12 Thread User Mkz
Log Message:
---
add server vars to SHOW FDS, relax result parsing

Modified Files:
--
pgbouncer/src:
admin.c (r1.13 -> r1.14)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/admin.c.diff?r1=1.13&r2=1.14)
objects.c (r1.17 -> r1.18)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/objects.c.diff?r1=1.17&r2=1.18)
objects.h (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/objects.h.diff?r1=1.3&r2=1.4)
proto.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/proto.c.diff?r1=1.5&r2=1.6)
takeover.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/takeover.c.diff?r1=1.3&r2=1.4)

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

   http://archives.postgresql.org


[COMMITTERS] pgunittest - pgUnitTest_Dev: New Directory

2007-08-12 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest_Dev/usr/help/example
In directory pgfoundry.org:/tmp/cvs-serv18505/usr/help/example

Log Message:
Directory /cvsroot/pgunittest/pgUnitTest_Dev/usr/help/example added to the 
repository


---(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] pgunittest - pgUnitTest_Dev: New Directory

2007-08-12 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest_Dev/usr/help/developer
In directory pgfoundry.org:/tmp/cvs-serv18505/usr/help/developer

Log Message:
Directory /cvsroot/pgunittest/pgUnitTest_Dev/usr/help/developer added to the 
repository


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


[COMMITTERS] pgunittest - pgUnitTest_Dev: New Directory

2007-08-12 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest_Dev/usr/help/deprecated
In directory pgfoundry.org:/tmp/cvs-serv18505/usr/help/deprecated

Log Message:
Directory /cvsroot/pgunittest/pgUnitTest_Dev/usr/help/deprecated added to the 
repository


---(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] pgunittest - pgUnitTest_Dev:

2007-08-12 Thread User Pgunittest
Log Message:
---


Modified Files:
--
pgUnitTest_Dev:
TODO (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/TODO.diff?r1=1.2&r2=1.3)
build.bat (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/build.bat.diff?r1=1.3&r2=1.4)
pgUnitTest_Dev/src/org/pgfoundry/pgunittest/generators:
GeneratorParser.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/src/org/pgfoundry/pgunittest/generators/GeneratorParser.java.diff?r1=1.1&r2=1.2)
RegexGenerator.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/src/org/pgfoundry/pgunittest/generators/RegexGenerator.java.diff?r1=1.1&r2=1.2)
pgUnitTest_Dev/src/org/pgfoundry/pgunittest/unittests:
RegexGeneratorTest.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/src/org/pgfoundry/pgunittest/unittests/RegexGeneratorTest.java.diff?r1=1.1&r2=1.2)
pgUnitTest_Dev/src/org/pgfoundry/pgunittest:
help.txt (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/src/org/pgfoundry/pgunittest/help.txt.diff?r1=1.1&r2=1.2)

Added Files:
---
pgUnitTest_Dev/usr/help/deprecated:
deprecated-doc.zip (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/deprecated/deprecated-doc.zip?rev=1.1&content-type=text/x-cvsweb-markup)
pgUnitTest_Dev/usr/help/example:
test.pgu (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/example/test.pgu?rev=1.1&content-type=text/x-cvsweb-markup)
data.pgu (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/example/data.pgu?rev=1.1&content-type=text/x-cvsweb-markup)
training.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/example/training.sql?rev=1.1&content-type=text/x-cvsweb-markup)
pgUnitTest_Dev/usr/help/developer:
developer.odt (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/developer/developer.odt?rev=1.1&content-type=text/x-cvsweb-markup)
developer.pdf (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/developer/developer.pdf?rev=1.1&content-type=text/x-cvsweb-markup)
pgUnitTest_Dev/files/testfiles:
regex.pgu (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/files/testfiles/regex.pgu?rev=1.1&content-type=text/x-cvsweb-markup)
pgUnitTest_Dev/usr/help:
pgUnitTest.pdf (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/pgUnitTest.pdf?rev=1.1&content-type=text/x-cvsweb-markup)
pgUnitTest.odt (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/pgUnitTest.odt?rev=1.1&content-type=text/x-cvsweb-markup)

Removed Files:
-
pgUnitTest_Dev/usr/help/faq:
language.pdf

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/faq/language.pdf)
generators.odt

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/faq/generators.odt)
language.odt

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/faq/language.odt)
FAQ.pdf

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/faq/FAQ.pdf)
FAQ.odt

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/faq/FAQ.odt)
generators.pdf

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/faq/generators.pdf)
pgUnitTest_Dev/usr/help/tutorial/end-user:
tutorial.odt

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/tutorial.odt)
training.sql

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/training.sql)
firstnames.txt

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/firstnames.txt)
trainees_data.pgu

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/trainees_data.pgu)
test.pgu

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/test.pgu)
trainees_test.pgu

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/trainees_test.pgu)
data.pgu

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Dev/usr/help/tutorial/end-user/dat

[COMMITTERS] pgsql: Increase the initial size of StringInfo buffers to 1024 bytes

2007-08-12 Thread Tom Lane
Log Message:
---
Increase the initial size of StringInfo buffers to 1024 bytes (from 256);
likewise increase the initial size of the scanner's literal buffer to 1024
(from 128).  Instrumentation of the regression tests suggests that this
saves a useful amount of repalloc() traffic --- the number of calls occurring
during one set of tests drops from about 6900 to about 3900.  The old sizes
were chosen in the late 90's with an eye to machines much smaller than
are common today.

Modified Files:
--
pgsql/src/backend/lib:
stringinfo.c (r1.46 -> r1.47)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/lib/stringinfo.c?r1=1.46&r2=1.47)
pgsql/src/backend/parser:
scan.l (r1.139 -> r1.140)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/scan.l?r1=1.139&r2=1.140)

---(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: Remove an "optimization" I installed in 2001, to make repalloc()

2007-08-12 Thread Tom Lane
Log Message:
---
Remove an "optimization" I installed in 2001, to make repalloc() attempt to
enlarge the memory chunk in-place when it was feasible to do so.  This turns
out to not work well at all for scenarios involving repeated cycles of
palloc/repalloc/pfree: the eventually freed chunks go into the wrong freelist
for the next initial palloc request, and so we consume memory indefinitely.
While that could be defended against, the number of cases where the
optimization can still be applied drops significantly, and adjusting the
initial sizes of StringInfo buffers makes it drop to almost nothing.
Seems better to just remove the extra complexity.
Per recent discussion and testing.

Modified Files:
--
pgsql/src/backend/utils/mmgr:
aset.c (r1.73 -> r1.74)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mmgr/aset.c?r1=1.73&r2=1.74)

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


[COMMITTERS] pgbouncer - pgbouncer: list.h: remove max_count as it was unused,

2007-08-12 Thread User Mkz
Log Message:
---
list.h: remove max_count as it was unused, disable list name tracking

Modified Files:
--
pgbouncer/src:
list.h (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/list.h.diff?r1=1.3&r2=1.4)

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

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


[COMMITTERS] pgbouncer - pgbouncer: varcache: remove overwrite arg, some logging

2007-08-12 Thread User Mkz
Log Message:
---
varcache: remove overwrite arg, some logging cleanup

Modified Files:
--
pgbouncer:
Makefile (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/Makefile.diff?r1=1.6&r2=1.7)
pgbouncer/src:
client.c (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/client.c.diff?r1=1.11&r2=1.12)
objects.c (r1.18 -> r1.19)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/objects.c.diff?r1=1.18&r2=1.19)
proto.c (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/proto.c.diff?r1=1.6&r2=1.7)
server.c (r1.10 -> r1.11)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/server.c.diff?r1=1.10&r2=1.11)
varcache.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/varcache.c.diff?r1=1.3&r2=1.4)
varcache.h (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/varcache.h.diff?r1=1.1&r2=1.2)

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


[COMMITTERS] pgbouncer - pgbouncer: wrap check order in quote_literal

2007-08-12 Thread User Mkz
Log Message:
---
wrap check order in quote_literal

Modified Files:
--
pgbouncer/src:
varcache.c (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/varcache.c.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] pgbouncer - pgbouncer: disable users before loading.

2007-08-12 Thread User Mkz
Log Message:
---
disable users before loading.

otherwise removing users wont work.

Modified Files:
--
pgbouncer/src:
loader.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/loader.c.diff?r1=1.3&r2=1.4)

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

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


[COMMITTERS] pgsql: Document that the regexp split functions ignore zero-length

2007-08-12 Thread Tom Lane
Log Message:
---
Document that the regexp split functions ignore zero-length matches in
certain corner cases.  Per discussion, the code does what we want, but
it really needs to be documented that these functions act differently
from regexp_matches.

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.384 -> r1.385)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.384&r2=1.385)

---(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