Hi,
We are running PostgreSQL 8.2.4 with quite highly updated millions rows
tables.
It comes sometimes to get some "idle in transaction" processes, which
doesn't have first really viewable effect out of giving very bad estimated
numbers for pgclass.reltuples and, if we let them run as it is, bloc
Στις Τρίτη 30 Οκτώβριος 2007 10:45, ο/η Patrick De Zlio έγραψε:
> Hi,
>
> We are running PostgreSQL 8.2.4 with quite highly updated millions rows
> tables.
>
> It comes sometimes to get some "idle in transaction" processes, which
> doesn't have first really viewable effect out of giving very bad es
On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> Στις Τρίτη 30 Οκτώβριος 2007 10:45, ο/η Patrick De Zlio έγραψε:
> > Hi,
> >
> > We are running PostgreSQL 8.2.4 with quite highly updated millions rows
> > tables.
> >
> > It comes sometimes to get some "idle in transaction" processes, wh
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
>> Some connection pools issue a BEGIN on the connection just
>> after the previous user of the connection issues COMMIT and
>> then closes it (Jboss does it). So, in transaction is not
>> apri
Στις Τετάρτη 31 Οκτώβριος 2007 23:47, ο/η Scott Marlowe έγραψε:
> On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > � 30 � 2007 10:45, �/� Patrick De
Zlio ��:
> > > Hi,
> > >
> > > We are running PostgreSQL 8.2.4 with quite highly updated millions rows
> > > table
On 11/1/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> Στις Î¤ÎµÏ„Î¬Ï Ï„Î· 31 ÎŸÎºÏ„ÏŽÎ²Ï Î¹Î¿Ï‚ 2007 23:47, ο/η Scott Marlowe
> ÎÎ³Ï Î±ÏˆÎµ:
> > On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > > Óôéò Ôñßôç 30 Ïêôþâñéïò 2007 10:45, ï/ç Patrick De
> Zlio Ýãñáøå:
> > > > H