From: Eduardo Morras <emorras@s21sec.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Followup: vacuum'ing toast
Date: Thu, 05 Nov 2009 10:04:05 +0100
Message-ID: <20091105090655.8EA085580B0@s21sec.com> (raw)
In-Reply-To: <4AF24006.1010509@postnewspapers.com.au>
References: <ca24673e0911041552k70b4af34k6f689ab116fc8752@mail.gmail.com>
<4AF229F5.201@2ndquadrant.com>
<4AF24006.1010509@postnewspapers.com.au>
>
>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ás González
Dept. I+D+i e-Crime Vigilancia Digital
S21sec Labs
Tlf: +34 902 222 521
Móvil: +34 555 555 555
www.s21sec.com, blog.s21sec.com
Salvo que se indique lo contrario, esta información es CONFIDENCIAL y
contiene datos de carácter personal que han de ser tratados conforme a la
legislación vigente en materia de protección de datos. Si usted no es
destinatario original de este mensaje, le comunicamos que no está autorizado
a revisar, reenviar, distribuir, copiar o imprimir la información en él
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.
Antes de imprimir este mensaje valora si verdaderamente es necesario. De
esta forma contribuimos a la preservación del Medio Ambiente.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: emorras@s21sec.com, craig@postnewspapers.com.au
Subject: Re: Followup: vacuum'ing toast
In-Reply-To: <20091105090655.8EA085580B0@s21sec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox