Re: Very slow queries on 8.1

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?