pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: pginfo <pginfo@t1.unisoftbg.com>
To: Ragnar Hafstað <gnari@simnet.is>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard_D_Levine@raytheon.com, Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg primary key bug?
Date: Tue, 22 Feb 2005 12:49:15 +0100
Message-ID: <421B1C3B.1020803@t1.unisoftbg.com> (raw)
References: <OFEF67063C.F61988F3-ON05256F9D.005A91D6@ftw.us.ray.com>
	<4214B466.20908@t1.unisoftbg.com>
	<8125.1108661189@sss.pgh.pa.us>
	<4214C94F.2050806@t1.unisoftbg.com>
	<9340.1108664352@sss.pgh.pa.us>
	<4214D5C3.4070107@t1.unisoftbg.com>
	<9785.1108666900@sss.pgh.pa.us>
	<421992FE.3030108@t1.unisoftbg.com>
	<3293.1109026294@sss.pgh.pa.us>
	<421AC251.7060806@t1.unisoftbg.com>
	<7012.1109061770@sss.pgh.pa.us>
	<421AFC7F.406@t1.unisoftbg.com>
	<1109073162.17839.124.camel@localhost.localdomain>



Ragnar Hafstað wrote:

>On Tue, 2005-02-22 at 10:33 +0100, pginfo wrote:
>  
>
>>  
>>We are using  jdbc (jdbc driver from pg)  + jboss (java based
>>application server) + connection pool (biult in jboss).
>>...
>>Will vacuum full generate this problem if we have locked table in this
>>time? (It is possible to have locked table in theory)
>>    
>>
>
>I do not know if this is relevant, but I have seen jboss applications
>keep sessions in 'Idle in transaction' state, apparently with some
>locks granted. Would such cases not interfere with vacuum?
>
>gnari
>
>  
>
Only to add,
also keeping sme transactions for long time not commited (possible).
regards,
ivan.

>
>
>  
>

view thread (27+ messages)  latest in thread

Message-ID: <421B1C3B.1020803@t1.unisoftbg.com>
Permalink:  ../421B1C3B.1020803@t1.unisoftbg.com/
Also on:    postgresql.org/message-id/421B1C3B.1020803@t1.unisoftbg.com

copy link · copy postgr.es

reply

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-sql@postgresql.org
  Cc: pginfo@t1.unisoftbg.com, gnari@simnet.is, tgl@sss.pgh.pa.us, grzm@myrealbox.com
  Subject: Re: pg primary key bug?
  In-Reply-To: <421B1C3B.1020803@t1.unisoftbg.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