Re: RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: >> BTW, have you looked into the theory that it's triggered by total >> data volume rather than number of columns? That is, try selecting >> all the columns but use LIMIT to reduce the number of rows fetched? > The where clause limits the number of r

RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
> "Scott Marlowe" <[EMAIL PROTECTED]> writes: > > On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > >> It=B4s "" but the "query_start" column is refreshed. > > > Then the query runs and finishes and the problem is something to do > > with the delivery of the data. Not sure after that... >

RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
> On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > > > SELECT * or naming all the columns locks the client > > > application. Yesterday > > > > I´ve wrongly said that when naming all the columns instead of > > > using the * > > > > th

RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
> "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > SELECT * or naming all the columns locks the client > application. Yesterday > > I´ve wrongly said that when naming all the columns instead of > using the * > > the applications did not lock. > > Hm, are you sure it's not one specific column that