From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | doc patch for savepoints |
Date: | 2006-11-27 22:08:45 |
Message-ID: | ekfnld$18sn$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
[jks(at)jks-work-desktop /tmp/tmp/postgresql-8.2rc1]$
src/tools/make_diff/difforig
./doc/src/sgml/ref/rollback_to.sgml
*** ./doc/src/sgml/ref/rollback_to.sgml.orig 2006-11-27
16:57:41.000000000 -0500
--- ./doc/src/sgml/ref/rollback_to.sgml 2006-11-27 17:02:43.000000000 -0500
***************
*** 69,74 ****
--- 69,80 ----
</para>
<para>
+ Rolling back a savepoint does not release it. It
+ will still be available for rolling back to, and it will still consume
+ shared memory until released.
+ </para>
+
+ <para>
Specifying a savepoint name that has not been established is an error.
</para>
./doc/src/sgml/ref/savepoint.sgml
*** ./doc/src/sgml/ref/savepoint.sgml.orig 2006-11-27
16:30:28.000000000 -0500
--- ./doc/src/sgml/ref/savepoint.sgml 2006-11-27 16:36:37.000000000 -0500
***************
*** 73,78 ****
--- 73,87 ----
Savepoints can only be established when inside a transaction block.
There can be multiple savepoints defined within a transaction.
</para>
+ <para>
+ Savepoints use shared memory. If you use many savepoints without
releasing them, you
+ will run out of shared memory and you may see an error like this in
your log:
+ <programlisting>
+ WARNING: out of shared memory
+ ERROR: out of shared memory
+ HINT: You may need to increase max_locks_per_transaction.
+ </programlisting>
+ </para>
</refsect1>
<refsect1>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Nixonn | 2006-11-27 22:17:20 | Re: Incrementing INET fields |
Previous Message | Andrew Dunstan | 2006-11-27 22:04:22 | Re: Storing a dynahash for an entire connection or |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-11-27 22:48:47 | Re: doc patch for savepoints |
Previous Message | Tom Lane | 2006-11-27 21:47:57 | Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3) |