Re: Very slow queries on 8.1

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.