Re: Very slow queries on 8.1

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?

In response to

Browse pgsql-general by date

  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