s to be "Heuristic overcommit handling". It seems
that what we want is "vm.overcommit_memory = 3" for paranoid overcommit.
Thanks for getting to the bottom of this Tom. It *is* insane that the
default isn't "paranoid overcommit".
--
-**-*-*---*-*---*-*---*-*
ns such as "suspend process, write image to file" and
"increase swap space" assume available disk space, which is obviously
not guaranteed to be avaliable.
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*---
Jon Lapham <[EMAIL PROTECTED]> Ri
an Weick is the author of
the Chapter 17 documentation, I guess I can send text to Jan.
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Jane
t; (changes
such that ALTER TABLE isn't able to help).
TIA, Jon
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-*-*-*-*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: [EMA
possible to have
EXPLAIN flag this type of problem? Remember, the EXPLAIN output for
7.1RC1 and 7.1.1 were identical.
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: [EMAIL PROTECTED] web
QUERY PLAN:
Seq Scan on tplantorgan (cost=0.00..237.30 rows=1 width=103)
EXPLAIN
main_v0_8=# update tplantorgan set active='f' where sampleid=100430;
UPDATE 1
main_v0_8=# select active from tplantorgan where sampleid=100430;
active
f
(1 row)
--
-**-*-*---*-*
AIN data for a v7.1RC1 db.
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-----*-*-*-*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: [EMAIL PROTECTED] web: http://www.extracta.com.br/
***-*--**---***---
---(end of broadcast)--
On Thu, May 10, 2001 at 05:56:11PM -0400, Tom Lane wrote:
> Jon Lapham <[EMAIL PROTECTED]> writes:
> > Yesterday I upgraded my database from Pg v7.1RC1 to v7.1.1. Since this
> > upgrade, I have been having unbelievable performance problems with updates
> > to a particu
n using child_pkey on child (cost=0.00..8.16 rows=5
width=4)
-> Index Scan using parent_pkey on parent (cost=0.00..8.16 rows=5
width=10)
NOTICE: QUERY PLAN:
Index Scan using child_pkey on child (cost=0.00..8.14 rows=10 width=14)
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*---
Jon
