Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group