[COMMITTERS] pgsql: Fix count_usable_fds() to stop trying to open files once it

2005-08-07 Thread Tom Lane
Log Message:
---
Fix count_usable_fds() to stop trying to open files once it reaches
max_files_per_process.  Going further than that is just a waste of
cycles, and it seems that current Cygwin does not cope gracefully
with deliberately running the system out of FDs.  Per Andrew Dunstan.

Modified Files:
--
pgsql/src/backend/storage/file:
fd.c (r1.118 -> r1.119)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/file/fd.c.diff?r1=1.118&r2=1.119)

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

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


[COMMITTERS] pgsql: Fix count_usable_fds() to stop trying to open files once it

2005-08-07 Thread Tom Lane
Log Message:
---
Fix count_usable_fds() to stop trying to open files once it reaches
max_files_per_process.  Going further than that is just a waste of
cycles, and it seems that current Cygwin does not cope gracefully
with deliberately running the system out of FDs.  Per Andrew Dunstan.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/backend/storage/file:
fd.c (r1.115 -> r1.115.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/file/fd.c.diff?r1=1.115&r2=1.115.4.1)

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


[COMMITTERS] pgsql: Fix count_usable_fds() to stop trying to open files once it

2005-08-07 Thread Tom Lane
Log Message:
---
Fix count_usable_fds() to stop trying to open files once it reaches
max_files_per_process.  Going further than that is just a waste of
cycles, and it seems that current Cygwin does not cope gracefully
with deliberately running the system out of FDs.  Per Andrew Dunstan.

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/src/backend/storage/file:
fd.c (r1.102.2.2 -> r1.102.2.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/file/fd.c.diff?r1=1.102.2.2&r2=1.102.2.3)

---(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: Set shlib naming convention on Cygwin to 'cygFOO.dll', which

2005-08-07 Thread Tom Lane
Log Message:
---
Set shlib naming convention on Cygwin to 'cygFOO.dll', which appears
to be the platform standard.  This should fix recursive-rule breakage
due to recent Makefile changes.  Per discussion.

Modified Files:
--
pgsql/src:
Makefile.shlib (r1.95 -> r1.96)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/Makefile.shlib.diff?r1=1.95&r2=1.96)

---(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] python - pq: Remove Argument, improve performance, use __slots__.

2005-08-07 Thread James William Pye
Log Message:
---
Remove Argument, improve performance, use __slots__.

Argument was a utility class that was mostly unneeded. It has been replaced with
a simple tuple object whose first item is the format and second item the data.

Use __slots__ on more objects to reduce memory footprint of instances.
Fix EmptyMessage instantiation so that it actually respects __slots__.

Inherit the Query message from string. The query is the only data, so it
justifies inheriting from StringType and disallowing further attributes.

Inherit TupleDescriptor, Tuple, and AttributeTypes from TupleType to improve
performance and reduce the memory footprint.

Fix tests to reflect changes.

Modified Files:
--
pq/src:
client3.py (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/src/client3.py.diff?r1=1.2&r2=1.3)
element3.py (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/src/element3.py.diff?r1=1.2&r2=1.3)
pq/test:
client3.py (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/test/client3.py.diff?r1=1.2&r2=1.3)
element3.py (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/test/element3.py.diff?r1=1.1.1.1&r2=1.2)

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

   http://archives.postgresql.org


[COMMITTERS] pgsql: Cause ShutdownPostgres to do a normal transaction abort during

2005-08-07 Thread Tom Lane
Log Message:
---
Cause ShutdownPostgres to do a normal transaction abort during backend
exit, instead of trying to take shortcuts.  Introduce some additional
shutdown callback routines to eliminate kluges like having ProcKill
be responsible for shutting down the buffer manager.  Ensure that the
order of operations during shutdown is predictable and what you would
expect given the module layering.

Modified Files:
--
pgsql/src/backend/bootstrap:
bootstrap.c (r1.205 -> r1.206)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/bootstrap/bootstrap.c.diff?r1=1.205&r2=1.206)
pgsql/src/backend/postmaster:
pgstat.c (r1.102 -> r1.103)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.102&r2=1.103)
pgsql/src/backend/storage/buffer:
buf_init.c (r1.73 -> r1.74)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/buf_init.c.diff?r1=1.73&r2=1.74)
bufmgr.c (r1.190 -> r1.191)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/bufmgr.c.diff?r1=1.190&r2=1.191)
pgsql/src/backend/storage/file:
fd.c (r1.119 -> r1.120)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/file/fd.c.diff?r1=1.119&r2=1.120)
pgsql/src/backend/storage/lmgr:
proc.c (r1.161 -> r1.162)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/proc.c.diff?r1=1.161&r2=1.162)
pgsql/src/backend/storage/smgr:
smgr.c (r1.91 -> r1.92)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/smgr/smgr.c.diff?r1=1.91&r2=1.92)
pgsql/src/backend/tcop:
postgres.c (r1.455 -> r1.456)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/postgres.c.diff?r1=1.455&r2=1.456)
pgsql/src/backend/utils/init:
postinit.c (r1.155 -> r1.156)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/postinit.c.diff?r1=1.155&r2=1.156)
pgsql/src/include/storage:
bufmgr.h (r1.93 -> r1.94)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/bufmgr.h.diff?r1=1.93&r2=1.94)
fd.h (r1.52 -> r1.53)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/fd.h.diff?r1=1.52&r2=1.53)

---(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] pgsql: Cygwin no longer needs to hack SHLIB_LINK, now that Rocco Altier

2005-08-07 Thread Tom Lane
Log Message:
---
Cygwin no longer needs to hack SHLIB_LINK, now that Rocco Altier
fixed the contrib library inclusions properly.

Modified Files:
--
pgsql/src:
Makefile.shlib (r1.96 -> r1.97)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/Makefile.shlib.diff?r1=1.96&r2=1.97)

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