Re: Very slow queries on 8.1 - Mailing list pgsql-general

From David Rysdam
Subject Re: Very slow queries on 8.1
Date
Msg-id 437CB5A8.5020809@ll.mit.edu
Whole thread Raw
In response to Re: Very slow queries on 8.1  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Bruno Wolff III wrote:

>On Thu, Nov 17, 2005 at 11:31:27 -0500,
>  David Rysdam <drysdam@ll.mit.edu> wrote:
>
>
>>Right, it's about 100k rows and it is through libpq (pgadmin in this
>>case, but my app uses libpq from pgtcl).  Is there a way to tell libpq
>>to not do what it "likes" and do what I need instead?  I didn't see
>>anything in the docs, but I didn't look very hard.
>>
>>
>
>You could use a cursor. That will bias the plan toward fast start plans which
>might give you lower throughput if you are normally planning to fetch all of
>the rows, but will give you quicker access to the first row.
>
>
>
>
That is exactly what I want, but is it possible to use a cursor from pgtcl?

pgsql-general by date:

Previous
From: David Rysdam
Date:
Subject: Re: Very slow queries on 8.1
Next
From: Michael Fuhr
Date:
Subject: Re: Very slow queries on 8.1