RE: Large selects handled inefficiently?

From: "Andrew Snow" <als(at)fl(dot)net(dot)au>
To: "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Large selects handled inefficiently?
Date: 2000-08-30 14:22:36
Message-ID: NHEALMDKDACEIPBNOOOCCEGBCLAA.als@fl.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I believe I can work around this problem using cursors (although I
> don't know how well DBD::Pg copes with cursors). However, that
> doesn't seem right -- cursors should be needed to fetch a large query
> without having it all in memory at once...

Actually, I think thats why cursors were invented in the first place ;-) A
cursor is what you are using if you're not fetching all the results of a
query.

- Andrew

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2000-08-30 14:37:01 Re: RE: even more CIDR weirdness (was equality operator on CIDR colum n as primary key)
Previous Message Ian Turner 2000-08-30 14:13:16 Re: PL/pgSQL