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

2007-10-15 Thread Tomasz Ostrowski
On Thu, 11 Oct 2007, Carlos H. Reimer wrote: > the problem happens with many machines where our Visual Basic > applications is running. After debuging the application we discovered that > the problem was always with "select *" statements. I'd try locally: $ psql -c 'select * from table where pk=

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

2007-10-11 Thread Gregory Stark
"Tom Lane" <[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? Or conversely select the first or second half of th