[COMMITTERS] pgbouncer - pgbouncer: code still tried to close fd, fix and clean up

2007-09-07 Thread User Mkz
Log Message:
---
code still tried to close fd, fix and clean up

Modified Files:
--
pgbouncer/src:
util.c (r1.15 -> r1.16)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/util.c.diff?r1=1.15&r2=1.16)

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

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


[COMMITTERS] pgbouncer - pgbouncer: todo update

2007-09-07 Thread User Mkz
Log Message:
---
todo update

Modified Files:
--
pgbouncer/doc:
todo.txt (r1.16 -> r1.17)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/doc/todo.txt.diff?r1=1.16&r2=1.17)

---(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] pgbouncer - pgbouncer: hack to use [,] in regex

2007-09-07 Thread User Mkz
Log Message:
---
hack to use [,] in regex

Modified Files:
--
pgbouncer:
configure.ac (r1.17 -> r1.18)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/configure.ac.diff?r1=1.17&r2=1.18)

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

   http://archives.postgresql.org


[COMMITTERS] pgbouncer - pgbouncer: new libevent wants clock_gettime() in -lrt

2007-09-07 Thread User Mkz
Log Message:
---
new libevent wants clock_gettime() in -lrt

Modified Files:
--
pgbouncer:
configure.ac (r1.16 -> r1.17)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/configure.ac.diff?r1=1.16&r2=1.17)

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

   http://archives.postgresql.org


[COMMITTERS] pgbouncer - pgbouncer: dont close logfile on first load

2007-09-07 Thread User Mkz
Log Message:
---
dont close logfile on first load

Modified Files:
--
pgbouncer/src:
main.c (r1.15 -> r1.16)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/main.c.diff?r1=1.15&r2=1.16)

---(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: Add turkish stopword list.

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Add turkish stopword list. Thanks to Devrim GUNDUZ <[EMAIL PROTECTED]>

Added Files:
---
pgsql/src/backend/snowball/stopwords:
turkish.stop (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/snowball/stopwords/turkish.stop?rev=1.1&content-type=text/x-cvsweb-markup)

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

   http://archives.postgresql.org


[COMMITTERS] pgsql: Fix indefinit loop in rank_cd for some corner queries.

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Fix indefinit loop in rank_cd for some corner queries.
Per Daniele Varrazzo <[EMAIL PROTECTED]> bug report.

Tags:

REL8_2_STABLE

Modified Files:
--
pgsql/contrib/tsearch2:
rank.c (r1.20.2.1 -> r1.20.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/rank.c?r1=1.20.2.1&r2=1.20.2.2)

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


[COMMITTERS] pgsql: Improving various checks by Heikki Linnakangas

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Improving various checks by Heikki Linnakangas <[EMAIL PROTECTED]>

- add code to check that the query tree is well-formed. It was indeed
  possible to send malformed queries in binary mode, which produced all
  kinds of strange results.

- make the left-field a uint32. There's no reason to
  arbitrarily limit it to 16-bits, and it won't increase the disk/memory
  footprint either now that QueryOperator and QueryOperand are separate
  structs.

- add check_stack_depth() call to all recursive functions I found.
  Some of them might have a natural limit so that you can't force
  arbitrarily deep recursions, but check_stack_depth() is cheap enough
  that seems best to just stick it into anything that might be a problem.

Modified Files:
--
pgsql/src/backend/utils/adt:
tsquery.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery.c?r1=1.3&r2=1.4)
tsquery_cleanup.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_cleanup.c?r1=1.2&r2=1.3)
tsquery_rewrite.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_rewrite.c?r1=1.2&r2=1.3)
tsquery_util.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_util.c?r1=1.2&r2=1.3)
tsrank.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsrank.c?r1=1.2&r2=1.3)
pgsql/src/include/tsearch:
ts_type.h (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_type.h?r1=1.2&r2=1.3)

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


[COMMITTERS] pgsql: Improvements from Heikki Linnakangas <[EMAIL PROTECTED]>

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Improvements from  Heikki Linnakangas <[EMAIL PROTECTED]>

- change the alignment requirement of lexemes in TSVector slightly.
Lexeme strings were always padded to 2-byte aligned length to make sure
that if there's position array (uint16[]) it has the right alignment.
The patch changes that so that the padding is not done when there's no
positions. That makes the storage of tsvectors without positions
slightly more compact.

- added some #include "miscadmin.h" lines I missed in the earlier when I
added calls to check_stack_depth().

- Reimplement the send/recv functions, and added a comment
above them describing the on-wire format. The CRC is now recalculated in
tsquery as well per previous discussion.

Modified Files:
--
pgsql/src/backend/utils/adt:
tsginidx.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsginidx.c?r1=1.2&r2=1.3)
tsquery.c (r1.4 -> r1.5)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery.c?r1=1.4&r2=1.5)
tsquery_cleanup.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_cleanup.c?r1=1.3&r2=1.4)
tsquery_rewrite.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_rewrite.c?r1=1.3&r2=1.4)
tsquery_util.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_util.c?r1=1.3&r2=1.4)
tsrank.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsrank.c?r1=1.3&r2=1.4)
tsvector.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector.c?r1=1.3&r2=1.4)
tsvector_op.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector_op.c?r1=1.3&r2=1.4)
pgsql/src/include/tsearch:
ts_type.h (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_type.h?r1=1.3&r2=1.4)

---(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: Improve page split in rtree emulation.

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Improve page split in rtree emulation. Now if splitted result has
big misalignement, then it tries to split page basing on distribution 
of boxe's centers.

Per report from  Dolafi, Tom <[EMAIL PROTECTED]>
 
 Backpatch is needed, change doesn't affect on-disk storage.

Modified Files:
--
pgsql/src/backend/access/gist:
gistproc.c (r1.10 -> r1.11)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistproc.c?r1=1.10&r2=1.11)

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


[COMMITTERS] pgsql: Improve page split in rtree emulation.

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Improve page split in rtree emulation. Now if splitted result has
big misalignement, then it tries to split page basing on distribution 
of boxe's centers.

Per report from  Dolafi, Tom <[EMAIL PROTECTED]>
 
 Backpatch is needed, changes doesn't affect on-disk storage.

Tags:

REL8_2_STABLE

Modified Files:
--
pgsql/src/backend/access/gist:
gistproc.c (r1.9 -> r1.9.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistproc.c?r1=1.9&r2=1.9.2.1)

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


[COMMITTERS] pgsql: Improve page split in rtree emulation.

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Improve page split in rtree emulation. Now if splitted result has
big misalignement, then it tries to split page basing on distribution 
of boxe's centers.

Per report from  Dolafi, Tom <[EMAIL PROTECTED]>

Tags:

REL8_1_STABLE

Modified Files:
--
pgsql/src/backend/access/gist:
gistproc.c (r1.3 -> r1.3.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistproc.c?r1=1.3&r2=1.3.2.1)

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


[COMMITTERS] pgbouncer - pgbouncer: mention loglived logfd

2007-09-07 Thread User Mkz
Log Message:
---
mention loglived logfd

Modified Files:
--
pgbouncer:
NEWS (r1.16 -> r1.17)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/NEWS.diff?r1=1.16&r2=1.17)

---(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: Refactoring by Heikki Linnakangas <[EMAIL PROTECTED]> with

2007-09-07 Thread Teodor Sigaev
Log Message:
---
Refactoring by Heikki Linnakangas <[EMAIL PROTECTED]> with
small editorization by me

- Brake the QueryItem struct into QueryOperator and QueryOperand. 
  Type was really the only common field between them. QueryItem still 
  exists, and is used in the TSQuery struct as before, but it's now a 
  union of the two. Many other changes fell from that, like separation 
  of pushval_asis function into pushValue, pushOperator and pushStop.

- Moved some structs that were for internal use only from header files
  to the right .c-files.

- Moved tsvector parser to a new tsvector_parser.c file. Parser code was
  about half of the size of tsvector.c, it's also used from tsquery.c, and
  it has some data structures of its own, so it seems better to separate
  it. Cleaned up the API so that TSVectorParserState is not accessed from
  outside tsvector_parser.c.

- Separated enumerations (#defines, really) used for QueryItem.type
  field and as return codes from gettoken_query. It was just accidental
  code sharing.

- Removed ParseQueryNode struct used internally by makepol and friends.
  push*-functions now construct QueryItems directly.

- Changed int4 variables to just ints for variables like "i" or "array
  size", where the storage-size was not significant.

Modified Files:
--
pgsql/src/backend/tsearch:
to_tsany.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/to_tsany.c?r1=1.1&r2=1.2)
ts_parse.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/ts_parse.c?r1=1.2&r2=1.3)
wparser_def.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/wparser_def.c?r1=1.2&r2=1.3)
pgsql/src/backend/utils/adt:
Makefile (r1.66 -> r1.67)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/Makefile?r1=1.66&r2=1.67)
tsginidx.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsginidx.c?r1=1.1&r2=1.2)
tsgistidx.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsgistidx.c?r1=1.2&r2=1.3)
tsquery.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery.c?r1=1.2&r2=1.3)
tsquery_cleanup.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_cleanup.c?r1=1.1&r2=1.2)
tsquery_op.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_op.c?r1=1.1&r2=1.2)
tsquery_rewrite.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_rewrite.c?r1=1.1&r2=1.2)
tsquery_util.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_util.c?r1=1.1&r2=1.2)
tsrank.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsrank.c?r1=1.1&r2=1.2)
tsvector.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector.c?r1=1.2&r2=1.3)
tsvector_op.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector_op.c?r1=1.2&r2=1.3)
pgsql/src/include/tsearch:
ts_public.h (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_public.h?r1=1.3&r2=1.4)
ts_type.h (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_type.h?r1=1.1&r2=1.2)
ts_utils.h (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_utils.h?r1=1.2&r2=1.3)

Added Files:
---
pgsql/src/backend/utils/adt:
tsvector_parser.c (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector_parser.c?rev=1.1&content-type=text/x-cvsweb-markup)

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

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


[COMMITTERS] pgbouncer - pgbouncer: remove track_parameters knob, no good usage

2007-09-07 Thread User Mkz
Log Message:
---
remove track_parameters knob, no good usage scenario

Modified Files:
--
pgbouncer/src:
objects.c (r1.22 -> r1.23)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/objects.c.diff?r1=1.22&r2=1.23)
main.c (r1.14 -> r1.15)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/main.c.diff?r1=1.14&r2=1.15)
bouncer.h (r1.15 -> r1.16)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/src/bouncer.h.diff?r1=1.15&r2=1.16)

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

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


[COMMITTERS] pgbouncer - pgbouncer: older asciidoc prints ver into stderr

2007-09-07 Thread User Mkz
Log Message:
---
older asciidoc prints ver into stderr

Modified Files:
--
pgbouncer:
configure.ac (r1.15 -> r1.16)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/configure.ac.diff?r1=1.15&r2=1.16)

---(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: Add Hash thread URL: >

2007-09-07 Thread Bruce Momjian
Log Message:
---
Add Hash thread URL:

>   http://archives.postgresql.org/pgsql-hackers/2007-09/msg00051.php

Modified Files:
--
pgsql/doc:
TODO (r1.2212 -> r1.2213)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2212&r2=1.2213)
pgsql/doc/src/FAQ:
TODO.html (r1.721 -> r1.722)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.721&r2=1.722)

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


[COMMITTERS] jdbccache - jdbccache: typo fix

2007-09-07 Thread User Kocka
Log Message:
---
typo fix

Modified Files:
--
jdbccache/wrapper-jdbc4/src/main/java/org/postgresql/wrapper/jdbc4:
WrapperConnection.java (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4/src/main/java/org/postgresql/wrapper/jdbc4/WrapperConnection.java.diff?r1=1.1.1.1&r2=1.2)
WrapperDataSource.java (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4/src/main/java/org/postgresql/wrapper/jdbc4/WrapperDataSource.java.diff?r1=1.1.1.1&r2=1.2)
WrapperPreparedStatement.java (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4/src/main/java/org/postgresql/wrapper/jdbc4/WrapperPreparedStatement.java.diff?r1=1.1.1.1&r2=1.2)

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

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


[COMMITTERS] jdbccache - jdbccache: New Directory

2007-09-07 Thread User Kocka
Update of 
/cvsroot/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper/jdbc4a
In directory 
pgfoundry.org:/tmp/cvs-serv35658/src/main/java/org/postgresql/wrapper/jdbc4a

Log Message:
Directory 
/cvsroot/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper/jdbc4a
 added to the repository


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


[COMMITTERS] jdbccache - jdbccache: New Directory

2007-09-07 Thread User Kocka
Update of 
/cvsroot/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper
In directory 
pgfoundry.org:/tmp/cvs-serv35658/src/main/java/org/postgresql/wrapper

Log Message:
Directory 
/cvsroot/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper
 added to the repository


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

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


[COMMITTERS] jdbccache - jdbccache: type in package name

2007-09-07 Thread User Kocka
Log Message:
---
type in package name

Removed Files:
-
jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapepr/jdbc4a:
AbstractWrapperConnection.java

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapepr/jdbc4a/AbstractWrapperConnection.java)
AbstractWrapperDataSource.java

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapepr/jdbc4a/AbstractWrapperDataSource.java)
AbstractWrapperPreparedStatement.java

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapepr/jdbc4a/AbstractWrapperPreparedStatement.java)

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


[COMMITTERS] jdbccache - jdbccache:

2007-09-07 Thread User Kocka
Log Message:
---


Added Files:
---
jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper/jdbc4a:
AbstractWrapperPreparedStatement.java (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper/jdbc4a/AbstractWrapperPreparedStatement.java?rev=1.1&content-type=text/x-cvsweb-markup)
AbstractWrapperConnection.java (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper/jdbc4a/AbstractWrapperConnection.java?rev=1.1&content-type=text/x-cvsweb-markup)
AbstractWrapperDataSource.java (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbccache/jdbccache/wrapper-jdbc4a/src/main/java/org/postgresql/wrapper/jdbc4a/AbstractWrapperDataSource.java?rev=1.1&content-type=text/x-cvsweb-markup)

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

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


[COMMITTERS] pgsql: Don't take ProcArrayLock while exiting a transaction that has no

2007-09-07 Thread Tom Lane
Log Message:
---
Don't take ProcArrayLock while exiting a transaction that has no XID; there is
no need for serialization against snapshot-taking because the xact doesn't
affect anyone else's snapshot anyway.  Per discussion.  Also, move various
info about the interlocking of transactions and snapshots out of code comments
and into a hopefully-more-cohesive discussion in access/transam/README.

Also, remove a couple of now-obsolete comments about having to force some WAL
to be written to persuade RecordTransactionCommit to do its thing.

Modified Files:
--
pgsql/src/backend/access/heap:
heapam.c (r1.238 -> r1.239)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c?r1=1.238&r2=1.239)
pgsql/src/backend/access/transam:
README (r1.7 -> r1.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/README?r1=1.7&r2=1.8)
xact.c (r1.248 -> r1.249)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c?r1=1.248&r2=1.249)
pgsql/src/backend/commands:
copy.c (r1.285 -> r1.286)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/copy.c?r1=1.285&r2=1.286)
pgsql/src/backend/executor:
execMain.c (r1.296 -> r1.297)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.296&r2=1.297)
pgsql/src/backend/storage/ipc:
procarray.c (r1.31 -> r1.32)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/procarray.c?r1=1.31&r2=1.32)

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