Re: Large selects handled inefficiently? - Mailing list pgsql-general

From Ross J. Reedstrom
Subject Re: Large selects handled inefficiently?
Date
Msg-id 20000906094432.A17080@rice.edu
Whole thread Raw
In response to Re: Large selects handled inefficiently?  (Jules Bean <jules@jellybean.co.uk>)
List pgsql-general
On Wed, Sep 06, 2000 at 09:33:07AM +0100, Jules Bean wrote:
>
> No, it's not really the DBD driver's fault.  There is no (easy) way
> around it, since the flaw lies in the C library it uses.  If the DBD
> driver wished to change behaviour, it could 'secretly' use cursors,
> but that would involve parsing queries to detect selects, which might
> be fragile.
>

Recent experience points out the fragility: the ODBC driver has an option
to try this: and there was just a bug report involving the driver's
attempts to use cursors with SELECT FOR UPDATE.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: install 7.0.2 host
Next
From: Andreas Tille
Date:
Subject: Re: 7.1 Release Date