Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 37140632EF7 for ; Thu, 5 Nov 2009 05:04:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09196-03 for ; Thu, 5 Nov 2009 09:04:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from s21sec.com (mail.s21sec.com [88.84.64.3]) by mail.postgresql.org (Postfix) with ESMTP id 3343A6322DD for ; Thu, 5 Nov 2009 05:04:15 -0400 (AST) Received: from PAM-INV-007.s21sec.com (178.Red-88-2-149.staticIP.rima-tde.net [88.2.149.178]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by s21sec.com (Postfix) with ESMTPSA id 8EA085580B0; Thu, 5 Nov 2009 10:06:55 +0100 (CET) X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9 Date: Thu, 05 Nov 2009 10:04:05 +0100 To: Craig Ringer From: Eduardo Morras Subject: Re: Followup: vacuum'ing toast Cc: pgsql-performance In-Reply-To: <4AF24006.1010509@postnewspapers.com.au> References: <4AF229F5.201@2ndquadrant.com> <4AF24006.1010509@postnewspapers.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <20091105090655.8EA085580B0@s21sec.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.397 tagged_above=-10 required=5 tests=BAYES_50=0.001, MIME_QP_LONG_LINE=1.396 X-Spam-Level: * X-Archive-Number: 200911/60 X-Sequence-Number: 36228 > >3) Autocommit being disabled. At least when using Hibernate via JPA, >that'll cause a major mess and would easily explain the issues you're >seeing. Hibernate manages transactions explicitly when required, and >expects autocommit to be off. Excuse me but i don't understand this point. You say that the problem= happens if Autocommit is disabled but that hibernates expects that= Autocommit is disabled for a correct work. What's better then? Autocommit= off for Hibernate or Autocommit On for the original poster problem. Can you= explain it more? Thanks >-- >Craig Ringe -------------------------------- Eduardo Morr=E1s Gonz=E1lez Dept. I+D+i e-Crime Vigilancia Digital S21sec Labs Tlf: +34 902 222 521 M=F3vil: +34 555 555 555=20 www.s21sec.com, blog.s21sec.com=20 Salvo que se indique lo contrario, esta informaci=F3n es CONFIDENCIAL y contiene datos de car=E1cter personal que han de ser tratados conforme a la legislaci=F3n vigente en materia de protecci=F3n de datos. Si usted no es destinatario original de este mensaje, le comunicamos que no est=E1= autorizado a revisar, reenviar, distribuir, copiar o imprimir la informaci=F3n en =E9l contenida y le rogamos que proceda a borrarlo de sus sistemas. Kontrakoa adierazi ezean, posta elektroniko honen barruan doana ISILPEKO informazioa da eta izaera pertsonaleko datuak dituenez, indarrean dagoen datu pertsonalak babesteko legediaren arabera tratatu beharrekoa. Posta honen hartzaile ez zaren kasuan, jakinarazten dizugu baimenik ez duzula bertan dagoen informazioa aztertu, igorri, banatu, kopiatu edo inprimatzeko. Hortaz, erregutzen dizugu posta hau zure sistemetatik berehala ezabatzea.=20 Antes de imprimir este mensaje valora si verdaderamente es necesario. De esta forma contribuimos a la preservaci=F3n del Medio Ambiente.=20