Re: Followup: vacuum'ing toast - Mailing list pgsql-performance

From Eduardo Morras
Subject Re: Followup: vacuum'ing toast
Date
Msg-id 20091105090655.8EA085580B0@s21sec.com
Whole thread Raw
In response to Re: Followup: vacuum'ing toast  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Followup: vacuum'ing toast  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
>
>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
hibernatesexpects that Autocommit is disabled for a correct work. What's better then? Autocommit off for Hibernate or
AutocommitOn 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.


pgsql-performance by date:

Previous
From: Jay Manni
Date:
Subject: Re: High Frequency Inserts to Postgres Database vs Writing to a File
Next
From: S Arvind
Date:
Subject: Running some query in low priority