Log Message:
---
Initial commit for resource scheduling (aka statement queuing).
Code is still WIP, lacking any user space commands, and without deadlocking
checking for the resource locks at all.
Modified Files:
--
bizgres/postgresql/src/backend/access/transam:
xa
Update of /cvsroot/bizgres/bizgres/postgresql/src/backend/utils/resscheduler
In directory pgfoundry.org:/tmp/cvs-serv54793/src/backend/utils/resscheduler
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/backend/utils/resscheduler
added to the repository
---
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/pg_kill
In directory pgfoundry.org:/tmp/cvs-serv75145/pg_kill
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/pg_kill added to the
repository
---(end of broadcast)---
TIP 6:
Log Message:
---
Add contrib module pg_kill discussed previously but not commited (suspect
everyone waiting for me, and I didn't have commit access...)
Module adds the pg_terminate_backend function together with a pair of views
which make remote cancel and terminate painless (perhaps too
Log Message:
---
Fix warning from pg_terminate_backend.c during compile - caused by a typo.
Standardize formatting in contrib directory Makefile.
Modified Files:
--
bizgres/postgresql/contrib:
Makefile (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvswe
Log Message:
---
Adopt a more coherent layout for this file. Discuss the data structures and
functions a little. Correct the E-R diagram (!) Correct some typos (probably
still some lurking).
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
READM
Log Message:
---
Add primitive deadlock detection code. This is achieved by calling the standard
deadlock detector and treating resource locks like exclusive standard locks. The
downside is overly aggressive detection - however safety is the initial goal.
The resource lock and proclock has
Log Message:
---
Add administration commands for resource queues.
The queues themselves are managed by CREATE|ALTER RESOURCE QUEUE xxx
ACTIVE THRESHOLD x1 COST THRESHOLD x2 plus DROP RESOURCE QUEUE xxx.
.
There are additions to the various ROLE commands to manage the associated
queue - CRE
Log Message:
---
Add commands to administer resource queues (continued).
...and the new files with the commands implemented!
Added Files:
---
bizgres/postgresql/src/backend/commands:
queue.c (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/p
Log Message:
---
Update and correct the README to provide a more complete picture.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backen
Log Message:
---
Resource scheduling added a new catalog - pg_resqueue, fix the regression test
expected files to take this into account.
Modified Files:
--
bizgres/postgresql/src/test/regress/expected:
rules.out (r1.1.1.3.2.1 -> r1.2)
(http://cvs.pgfoundry
Log Message:
---
Use a hash table for the (in memory) resource queues.
An array was use initially - the hash should scale better as the number of
queues increases.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resqueue.c (r1.3 -> r1.4)
Log Message:
---
Add code to catch deadlocking against self (e.g. opening 6 cursors when you
belong to a queue with active threshold 5).
This could be used to handle the case of 1 statement with a cost higher than
the queue cost threshold (currently allow overcommit if it is the only acti
Log Message:
---
Document the catalog changes for Resource Scheduling.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/utils/ress
Log Message:
---
Amend self deadlock algorithm for resource scheduling, it was being brain dead
and continuing to scan the lock list after finding a holder that wasn't me,
changed to stop the scan when this happens.
Modified Files:
--
bizgres/postgresql/src/backend/storag
Log Message:
---
Remove build generated files.
Removed Files:
-
bizgres/postgresql/src/backend/bootstrap:
bootparse.c
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/bootstrap/bootparse.c)
bootscanner.c
(
Log Message:
---
Allow set role to change the resource queue to that of the new role.
Statements opened or executing under the old queue continue to operate as if the
role change did not happen.
Modified Files:
--
bizgres/postgresql/src/backend/utils/init:
miscinit.
Log Message:
---
Fix bug whereby the first query of a new session will not deduct its portal
increments if interrupted. This was due to waitPortalId not being
set at backend process startup.
Modified Files:
--
bizgres/postgresql/src/backend/storage/lmgr:
proc.c (r1.
Log Message:
---
Make the parsing of queue thresholds a little better - in the active case we
can now avoid float format, but unfortunately need to keep it for cost.
The reason being my lack of comfort in having a max cost threshold of 1e+19,
given we (or I anyway) don't seem to have any h
Log Message:
---
Make resource queues show up as such in pg_locks. In the interest of backward
compatability, new columns were *not* added to the view, so the resource
queue id shows up under objid - which seems reasoanble I think.
Modified Files:
--
bizgres/postgresql/src
Log Message:
---
Eliminate a compile warning by declaring LogicalTapeSetForgetFreeSpace.
Modified Files:
--
bizgres/postgresql/src/include/utils:
logtape.h (r1.1.1.2.2.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/in
Log Message:
---
Apply review patch from Gavin Sherry, with minor editorial changes.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
queue.c (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/comma
Log Message:
---
Update OID numbers for catalog changes to avoid clash with Postgres 8.2.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src
Log Message:
---
Remove spurious debugging message displaying query type.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
prepare.c (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/commands/prepa
Log Message:
---
Fix bug whereby ROLLBACK TO SAVEPOINT would not release appropriate resource
locks. This was caused by complete lack of any resource owner being associated
with resource lock and portal increment data structures.
Modified Files:
--
bizgres/postgresql/src/b
Log Message:
---
Fix big whereby cursors declared WITH HOLD would have their resource locks
released prematurely.
As part of the change, merge largely repeated code in ResLockRelaseAll and
ResProcReleaseCurrentOwner.
Modified Files:
--
bizgres/postgresql/src/backend/comman
Log Message:
---
Fix DROP RESOURCE QUEUE so that it destroys the in memory queue along with
the catalog queue object. This does mean that it is possible to have foot gun
moments via ALTER ROLE ... RESOURCE QUEUE for a connected user and then
DROP RESOURCE QUEUE on the role's queue. However
Log Message:
---
Rationalize warnings about resource scheduler off for CREATE|ALTER|DROP
RESOURCE QUEUE.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
queue.c (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgre
Log Message:
---
Prevent ALTER RESOURCE QUEUE setting all limits to be invalid/ignored.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
queue.c (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/co
Log Message:
---
Allow for unamed portals in checking of max_portals_per_transaction, it seems
easier to just allow 1 extra slot in the portal hash and only count named
portals.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resqueue.c (r1.8
Log Message:
---
unset LOCK_DEBUG symbol that had (ahem) somehow got defined...
Modified Files:
--
bizgres/postgresql/src/include:
pg_config_manual.h (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/pg_confi
Log Message:
---
Also remove the extra whitespace that had crept in.
Modified Files:
--
bizgres/postgresql/src/include:
pg_config_manual.h (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/pg_config_manual.h.
Log Message:
---
Initial checkin of documentation for resource scheduling.
Modified Files:
--
bizgres/postgresql/doc/src/sgml:
catalogs.sgml (r1.1.1.2.2.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/src/sgml/catalogs
Log Message:
---
Correct typo in check for all thresholds set to invalid.
Modified Files:
--
bizgres/postgresql/doc:
postgres.tar.gz (r1.1.1.2 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/postgres.tar.gz.diff?r1=1.1.1
Log Message:
---
Remove the generated html docs file from the CVS repository - as we should
generated a fresh one for any release!
Removed Files:
-
bizgres/postgresql/doc:
postgres.tar.gz
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgres
Log Message:
---
Next installment of resource scheduler documentation.
Modified Files:
--
bizgres/postgresql/doc/src/sgml:
catalogs.sgml (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/src/sgml/catalogs.sgml.diff?r
Log Message:
---
Remove generated manual pages, as we need to build this for a release.
Removed Files:
-
bizgres/postgresql/doc:
man.tar.gz
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/man.tar.gz)
---(
Log Message:
---
Documentation proof reading and clean-ups
Modified Files:
--
bizgres/postgresql/doc/src/sgml:
config.sgml (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/src/sgml/config.sgml.diff?r1=1.4&r2=1.5)
Log Message:
---
Mention that attempts to alter a resource queue that is in use are prevented.
Modified Files:
--
bizgres/postgresql/doc/src/sgml/ref:
alter_resource_queue.sgml (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/post
Log Message:
---
Add missing check for all invalid thresholds to CREATE RESOURCE QUEUE. Also
add missing {} around two code blocks that check threshold ranges.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
queue.c (r1.6 -> r1.7)
(http://cvs.pg
Log Message:
---
Show a warning for CREATE|ALTER ROLE if rolresqueue is included in the create
oralter and resource_scheduler=off.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
user.c (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cg
Log Message:
---
Enable resource queue overcommit to be set on a per queue basis.
Statements that have individual increments bigger than any cost related
threshold will cause statement abort. The default for resource queues is
no overcommit.
Modified Files:
--
bizgres/post
Log Message:
---
Documentation for resource queue overcommit option.
Modified Files:
--
bizgres/postgresql/doc/src/sgml:
catalogs.sgml (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/src/sgml/catalogs.sgml.diff?r1=
Log Message:
---
Minor corrections to links for resource queue documentation.
Modified Files:
--
bizgres/postgresql/doc/src/sgml/ref:
alter_resource_queue.sgml (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/src/sg
Log Message:
---
Add an option to dump resource queue and role to resource queue associations.
Modified Files:
--
bizgres/postgresql/doc/src/sgml/ref:
pg_dumpall.sgml (r1.1.1.2.2.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgr
Log Message:
---
Amend ALTER|CREATE USER to mention resource queue.
Modified Files:
--
bizgres/postgresql/doc/src/sgml/ref:
alter_user.sgml (r1.1.1.2.2.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/doc/src/sgml/ref/alter
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/hstore/data
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/hstore/data
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/hstore/data added to the
repository
---(end of broadcast)---
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/adminpack
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/adminpack
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/adminpack added to the
repository
---(end of broadcast)-
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/hstore
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/hstore
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/hstore added to the
repository
---(end of broadcast)---
TI
Update of /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/connect
In directory pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/connect
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/connect
added to the repository
-
Update of
/cvsroot/bizgres/bizgres/postgresql/src/backend/utils/mb/conversion_procs/utf8_and_win
In directory
pgfoundry.org:/tmp/cvs-serv74396/src/backend/utils/mb/conversion_procs/utf8_and_win
Log Message:
Directory
/cvsroot/bizgres/bizgres/postgresql/src/backend/utils/mb/conversion_procs/utf8
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/hstore/sql
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/hstore/sql
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/hstore/sql added to the
repository
---(end of broadcast)--
Update of /cvsroot/bizgres/bizgres/postgresql/src/tools/editors
In directory pgfoundry.org:/tmp/cvs-serv74396/src/tools/editors
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/tools/editors added to the
repository
---(end of broadcast)-
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/hstore/expected
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/hstore/expected
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/hstore/expected added to
the repository
---(end of broadcast)---
Update of /cvsroot/bizgres/bizgres/postgresql/src/test/thread
In directory pgfoundry.org:/tmp/cvs-serv74396/src/test/thread
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/test/thread added to the
repository
---(end of broadcast)---
Update of /cvsroot/bizgres/bizgres/postgresql/src/timezone/tznames
In directory pgfoundry.org:/tmp/cvs-serv74396/src/timezone/tznames
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/timezone/tznames added to the
repository
---(end of broadcast)
Update of
/cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/pgtypeslib
In directory
pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/pgtypeslib
Log Message:
Directory
/cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/pgtypeslib added
to the repository
-
Update of /cvsroot/bizgres/bizgres/postgresql/src/include/port/win32_msvc/sys
In directory pgfoundry.org:/tmp/cvs-serv74396/src/include/port/win32_msvc/sys
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/include/port/win32_msvc/sys
added to the repository
Update of /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/preproc
In directory pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/preproc
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/preproc
added to the repository
-
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/isn
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/isn
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/isn added to the
repository
---(end of broadcast)---
TIP 1: if p
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/pgrowlocks
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/pgrowlocks
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/pgrowlocks added to the
repository
---(end of broadcast)--
Update of /cvsroot/bizgres/bizgres/postgresql/src/tools/msvc
In directory pgfoundry.org:/tmp/cvs-serv74396/src/tools/msvc
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/tools/msvc added to the
repository
---(end of broadcast)---
TI
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/pg_freespacemap
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/pg_freespacemap
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/pg_freespacemap added to
the repository
---(end of broadcast)---
Update of /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/thread
In directory pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/thread
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/thread
added to the repository
Update of /cvsroot/bizgres/bizgres/postgresql/src/include/port/win32_msvc
In directory pgfoundry.org:/tmp/cvs-serv74396/src/include/port/win32_msvc
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/include/port/win32_msvc added
to the repository
---(end of b
Update of /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/sql
In directory pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/sql
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/sql
added to the repository
---(end o
Update of /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/expected
In directory pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/expected
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/expected
added to the repository
--
Update of /cvsroot/bizgres/bizgres/postgresql/contrib/sslinfo
In directory pgfoundry.org:/tmp/cvs-serv74396/contrib/sslinfo
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/contrib/sslinfo added to the
repository
---(end of broadcast)---
Update of
/cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/performance
In directory
pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/performance
Log Message:
Directory
/cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/performance added
to the repository
--
Update of
/cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/compat_informix
In directory
pgfoundry.org:/tmp/cvs-serv74396/src/interfaces/ecpg/test/compat_informix
Log Message:
Directory
/cvsroot/bizgres/bizgres/postgresql/src/interfaces/ecpg/test/compat_informix
added to the reposit
Update of /cvsroot/bizgres/bizgres/postgresql/src/backend/access/gin
In directory pgfoundry.org:/tmp/cvs-serv74396/src/backend/access/gin
Log Message:
Directory /cvsroot/bizgres/bizgres/postgresql/src/backend/access/gin added to
the repository
---(end of broadcast)--
Log Message:
---
Bizgres 8.2 merge continued: (re) add some zero length files that were
inadvertently removed!
Added Files:
---
bizgres/postgresql/src/backend/port/tas:
dummy.s (r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/
Log Message:
---
Get resource queuing working. There is more code to come here, but this
commit gets the 8.2 infrastructure in there.
Modified Files:
--
bizgres/postgresql/src/backend/commands:
queue.c (r1.9 -> r1.10)
(http://cvs.pgfoundry.org/cgi-bin/cvswe
Log Message:
---
Tidy up contrib.
Modified Files:
--
bizgres/postgresql/contrib:
Makefile (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/contrib/Makefile.diff?r1=1.4&r2=1.5)
---(end of broadca
Log Message:
---
Bring resource queue code up-to-date:
- Move resource lock taking location to PortalStart
- Simplify cursor handling code as a result
- Cleanup code to handle overcommit abort correctly
- Add internal view pg_resqueue_status
- Add statistics monitoring infrastructure and vi
Log Message:
---
Fix inconsistent visibility declarations with LockData structures.
Also add in a couple of Asserts that were left off.
Modified Files:
--
bizgres/postgresql/src/backend/storage/lmgr:
lock.c (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/c
Log Message:
---
Restore Bizgres tuned defaults for shared_buffers, work_mem and
maintenance_work_mem. These probably could do with some looking at again - but
at least they agree with the configuration file now!
Modified Files:
--
bizgres/postgresql/src/backend/utils/misc
Log Message:
---
Fix expected regression test output to include resource relations and
attributes.
Modified Files:
--
bizgres/postgresql/src/test/regress/expected:
rules.out (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgr
Log Message:
---
Update documentation for lastest resource queuing additions:
- new views pg_resqueue_status, pg_stat_resqueues.
- ALTER RESOURCE QUEUE possible for active queues.
Modified Files:
--
bizgres/postgresql/doc/src/sgml:
catalogs.sgml (r1.5 -> r1.6)
Log Message:
---
Add the code to allow active resource queues to be altered. This patch was
ommitted in the previous commit!
Modified Files:
--
bizgres/postgresql/src/backend/commands:
queue.c (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bi
Log Message:
---
Update the README to reflect the code changes.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/utils/resschedu
Log Message:
---
Make bmcostestimate call genericcostestimate again, it had been #if'ed out
during the merge.
Modified Files:
--
bizgres/postgresql/src/backend/utils/adt:
selfuncs.c (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres
Log Message:
---
Fix cursors decleared WITH HOLD. This uncovered some unnoticed bugs created
by previous changes that move where ResLockPortal was being called from. In
this change we:
- Move location of ResUnLockPortal from PortalRun to PortalDrop,
this vastly simplifies most abort and
Log Message:
---
Update the README to reflect the new call locations and signatures for:
ResLockPortal
ResUnLockPortal
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.11 -> r1.12)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb
Log Message:
---
Fix self (dead)lock check to work correctly - iterate through my portals and
see if I have total increments higher than any corresponding thresholds.
Modified Files:
--
bizgres/postgresql/src/backend/storage/lmgr:
proc.c (r1.9 -> r1.10)
(ht
Log Message:
---
Take the ResQueueLock LW lock right at the start of the selfdeadlock check,
to avoid possible race condition.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resqueue.c (r1.15 -> r1.16)
(http://cvs.pgfoundry.org/cgi-bi
Log Message:
---
Fix the resource_select_only=false case - we were not bothering to take a
resource lock at all. This was broken when ResLockPortal call was moved to
PortalStart - we need to place a copy in ProcessQuery to catch UPDATE/INSERT/
DELETE.
Modified Files:
--
bi
Log Message:
---
Make SET SESSION AUTHORIZATION set the resource queue id.
Modified Files:
--
bizgres/postgresql/src/backend/utils/init:
miscinit.c (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/utils/init
Log Message:
---
Handle empty statement. Some housekeping for resource scheduling was assuming
that parsetrees were always non-trivial.
Modified Files:
--
bizgres/postgresql/src/backend/tcop:
postgres.c (r1.6 -> r1.7)
(http://cvs.pgfoundry.org/cgi-bin/cvswe
Log Message:
---
Update from 8.2.3 to 8.2.4 Postgres codebase.
Modified Files:
--
bizgres/postgresql:
HISTORY (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/HISTORY.diff?r1=1.2&r2=1.3)
INSTALL (r1.2 -> r1.3)
Log Message:
---
When checking portals with strategy PORTAL_MULTI_SELECT need to consider cases
that are SELECT type statements (CREATE TABLE AS SELECT), and lock these even
if resource_select_only is off.
Modified Files:
--
bizgres/postgresql/src/backend/tcop:
pq
Log Message:
---
Fix bogus 'locking against self' error for overcommitted queues.
Modified Files:
--
bizgres/postgresql/src/backend/utils/mmgr:
portalmem.c (r1.7 -> r1.8)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/ut
Log Message:
---
Resource Scheduler tidy:
Remove never executed code sections from ResLockPortal.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resscheduler.c (r1.14 -> r1.15)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/biz
Log Message:
---
Resource Scheduler tidy:
Correct comments for TotalResPortalIncrements.
Modified Files:
--
bizgres/postgresql/src/backend/utils/mmgr:
portalmem.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/ba
Log Message:
---
Add new psuedo threshold type 'IGNORE' - queries whose cost is less than this
are not queued at all! This should make queueing work better with ad-hoc
tools that do a lot of catalog lookups before running actual queries.
Initdb is forced (changes to pg_resqueue).
Modified
Log Message:
---
Update README for overcommit and ignore threshold changes.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.12 -> r1.13)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/uti
Log Message:
---
Fix self deadlock breakage introduced by ignore functionality.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resqueue.c (r1.18 -> r1.19)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/bac
Log Message:
---
Use definable symbol RESLOCK_DEBUG to conditionally remove debugging elog calls
in (potentially) performance critical parts of the (resource) locking logic.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
README (r1.13 -> r1.14
Log Message:
---
Correct declaration for global structure ResScheduler.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resscheduler.c (r1.18 -> r1.19)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend
Log Message:
---
Release partitioned LWLocks in reverse order to their acquisition in view
pg_resqueue_status.
Modified Files:
--
bizgres/postgresql/src/backend/utils/resscheduler:
resqueue.c (r1.20 -> r1.21)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bi
100 matches
Mail list logo
