From: | David Rysdam <drysdam(at)ll(dot)mit(dot)edu> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Very slow queries on 8.1 |
Date: | 2005-11-17 16:54:00 |
Message-ID: | 437CB5A8.5020809@ll.mit.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bruno Wolff III wrote:
>On Thu, Nov 17, 2005 at 11:31:27 -0500,
> David Rysdam <drysdam(at)ll(dot)mit(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2005-11-17 16:59:43 | Re: Numeric 508 datatype |
Previous Message | David Rysdam | 2005-11-17 16:53:15 | Re: Very slow queries on 8.1 |