Re: Limit vs setMaxRows issue - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: Limit vs setMaxRows issue
Date
Msg-id 44B4D610.9010105@logix-tt.com
Whole thread Raw
In response to Re: Limit vs setMaxRows issue  (Marc Herbert <Marc.Herbert@continuent.com>)
List pgsql-jdbc
Hi, Marc,

Marc Herbert wrote:

> Even if you delay the parsing on the first execution in order to wait
> for any helpful but late .setMaxRows(), then later .setMaxRows() on
> the next re-executions will come after parsing anyway. Unless you
> kinda re-parse every time...

Only when setMaxRows() actually changes.

And theoretically, only re-planning is required, not re-parsing, but
currently the server does not allow clients to control those steps
independently.

HTH,
Markus


--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-jdbc by date:

Previous
From: Marc Herbert
Date:
Subject: Re: Limit vs setMaxRows issue
Next
From: "Lucas Sousa"
Date:
Subject: Re: executeQuery Locked