Postgres Pro
Downloads
Home   >   mailing lists

Re: DDL commands take forever - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: DDL commands take forever
Date
Msg-id 4B3A6F28.3050101@iol.ie
Whole thread Raw
In response to Re: DDL commands take forever  ("Leonardo M." Ramé <l.rame@griensu.com>)
List pgsql-general
Tree view 
On 29/12/2009 20:59, Leonardo M. Ramé wrote:

> in "<IDLE> in transaction". The interesting thing is the app is doing
> only Selects, without opening transactions.

Everything in PG happens in a transaction, whether you open one
explicitly or not.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: DDL commands take forever
Next
From: Alvaro Herrera
Date:
Subject: Re: memory usage of group by select